Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invoice Distributions for Drop ships 2

Status
Not open for further replies.

hartofmine

Technical User
Oct 19, 2005
15
0
0
US
We are having an problem with the invoicing distributions when we post a drop ship order. We have a mysterios entry showing up at the end that is not visible in the original distribution screen. It is type for inv and cogs. Does anyone one know where it is coming from.

Thanks.
 
from the line item itself

select the line, expand it and check it's individual distribution

-----------
and they wonder why they call it Great Pains!

jaz
 
Inventory and Cost of Goods Sold are created during invoice posting and like jaz said check the line distribution. this is by design because the cost of the items are not know until the invoice is posted.

if item line distribution is blank you can manually enter accounts, some companies do this whenever a non-inventoried item is entered but there are a couple of ways to do it.
 
Are we talking on the purchase order side or the sales order side?

Thanks,
Dawn
 
In purchasing side, if you create a Drop-ship PO and do a Purchasing Invoice the entry would be DR to the Drop-ship account setup in the item or if blank to the Posting Accounts setup and CR to the payables account from vendor.
 
That is what we are currently doing. However, when we do the sales order and transfer it to an invoice is when we get this mysterious entry.
 
did you check the sales line item distribution already? do you commit or link your sales order to a PO?
 
Yes, we have check all the line distributions. We purchase after we have entered the sales order with the purchase button at the top of the sales transaction form.
 
The INV and COGS should be coming from the item account. look for the Dop-ship items and Cost of Goods Sold accounts. if this isn't the accounts then somebody must have entered it manually. is this a regular item in your inventory?
 
I will check this. Yes, it is the items that are inventory but we are drop shipping from a vendor because we don't have stock.
 
in that case the accounts should be getting it from the item card. if the drop ship items account is blank on the item card the system would look at the posting setup for inventory (Setup>Posting>Posting Setup>Display:Inventory) then drop ship items.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top