Setup multiple misc. charges (not Inventory item) with default GL account

[Former Member]

We need issue debit memo (will use AR invoice since no DM) for additional Misc. charges in different types like additional freight, additional labor, small repair parts...etc. Would like to setup codes with default GL account.

If can setup by unique code for each Misc. charge with default GL account will be the best to analyze the data.

Edited by: Lily Chien on May 22, 2009 2:20 AM

[Former Member]

For these (I assume non-stock items) go to the Item Master Data -> Stock Data tab and choose Set G/L Accounts by: Item Level. Then with the Form Settings display all the G/L accounts you wish to set and so you can have different accounts for each and every item.

[Former Member]

No luck, I setup the inventory GL code by item group. I tried to setup inventory master data with "Sales" item only (but can not uncheck the check mark from inventory and purchase).

How to remove those check marks (grayed out) and not need to go by any Item Group, but need default to one GL code will be great?

[Former Member]

Once there are transactions with that item, you cannot untick those tickboxes anymore. You might want to set up new items.

Try to set the G/L accounts by Item level and not Item Group.

[zal_parchem2]

Hello Lily - a suggestion for you...just a different way to add those charges besides using the Inventory Module.

We set up Miscellaneous Charges by using Administration > Set Up > General > Freight and input the description and GL Accounts there. SAP has B1 documentation titled "Additional Expenses in Sales and Purchasing Documents" which covers this topic and it is only about 15 pages or so...

The only drawback is that the charges appear in the "Freight" field on the document and you must use the golden drill-down arrow to see exactly what is contained in the dollar amount in the "Freight" field.

We also changed the document field name from "Freight" to "FRT and MISC"...

Hope that helps...

Thanks Zal

[Former Member]

Zal,

I added new Sales Item (not Inventory or Purchase item) and change this to Labor type with Misc. Item Group which I default to a specific revenue account.

I created an invoice with this Sales Item that works. I believe this item won't be calculate the qty since this is not Inventory item. I will see any better solution than this way. Thanks.