Item Charge Assignment

Hi Dug,

I was experiencing problems with Item Charge Assignment on Sales Invoice.

Example Given:

Default setup on the item card.

No: Item0001

Base UOM: PCS

Unit Cost: 1000

Unit Price: 2000

Purchases:

Type No. Quantity Unit of Measure Direct Cost Excld. VAT Line Amount

Item Item0001 1 PCS 1000 1000

Charges (Item) Freight 1 500 500

Entries on General Ledger

Db Inventory 1500

Cr Accounts Payable 1500

Sales:

Type No. Quantity Unit of Measure Unit Price Excld. VAT Unit Cost Line Amount

Item Item0001 1 PCS 2000 1000 2000

Charges (Item) Freight 1 500 500

Entries on General Ledger:

Db Cost of Sales 1000

Cr Inventory 1000

Db Account Receivables 2000

Cr Sales 2000

There is a floating 500 on inventory. Inventory balances should be 0. Can you help me on this.

Regards.

Francis

hi,

have you ran adjust cost - item entries batch yet ?

g.