invoice line question

[mm236]

We have line level detail that is being run through the invoicing program.

These lines generate credits to the customer but the units do not impact inventory even though there is a unit quantity in the line.

We are being told that there is no way to run these lines through invoicing without GP adjusting inventory.

We would like to only calculate and apply the credit, and ignore the qty or unit amount on the line (but still capture it for reporting and analysis purposes).

Does anyone know if this is possible in GP?

Thanks

 

[barbola]

Are you using an item number? If the item is set up as a non-inventory item, such as flat fee or services, then it doesn't accumulate any inventory quantities.

You don't even need to use an item number, but it's easier for letting proper GL accounts default into the distributions.

Is that what you were looking for?

 

[Dukester0122]

you can use non-inventoried items or even drop-ship items. try to test both and see which one works for you. drop-ship don't affect inventory quantities like non-inventoried items. you have to decide which process would work for your reports.

 

[mm236]

Thanks for your responses.
It is actually a valid SKU for an item that we track inventory and bill.

To explain it further, the wholesale customer overpays us... say $100 for 1 SKU(unit) and their true price(contract price) is $15.

A month from now, a the wholesale customer sells that unit to a retailer or small store.

The wholesaler transmits back to us, line level detail of the sale out to the retailer (the name of the retailer, the SKU, the qty).

We run the lines through the invoicing program to generate the $85 credit but the qty value is just informational.

Other ERP systems just have different financial reason codes/journal entry models set up for the different types of lines that flow through billing.

This type would generate a credit but not touch inventory even thoughit is for a SKU that we track inventory on.

We would want these transactions all applied to the one SKU so that we could net out the overpriced sale against the credit back to the wholesaler for the selling the unit to the retailer, to get the $15 in the example.

The consultants here set up a dummy SKU for each item to process these credits.

So sales go against one SKU and these credits go against a different SKU even though it is for the same item.

Thanks.