Share
ReportI am really hoping someone, anyone, on here can help me. I feel like I"m just running in circles.
A year or 2 ago our company started using a WMS outside of GP, that is also a SQL program that both pulls data from GP and writes back to it. Unfortunately, when we got ASC only a couple of people were really experts, and they have both since left the company. We have also had an issue for a few years that our previous inventory /cost accountant wasn't able to figure out, so we basically just end up doing journal entries every month to match GP to ASC (assuming ASC is the correct system because this is was our receiving department and production department use). The issue is this:
- We generally receive orders from our customers EDI and they feed directly to GP
- The order is created, and then sent to ASC for fulfilment
- Production picks, manufactures, packages ships and fulfills the order using ASC
- ASC writes back to GP so the invoice can be created
The problem is that we have 3 location, for which we use the segments feature in GP, depending on which warehouse fulfils the order it should use either the 01, 02, or 03 inventory/COGS accounts. This only works some of the time, however. Default accounts are not set at the customer or posting level (at least for the inventory), I only have a default on the item card, because after researching here my understanding was that the default won't matter as long as the Site ID is correct and when I tried to run a test order with no account in any of those spots, it won't post (which makes sense). So, in our live environment the orders sometimes write back using the correct inventory and COGS accounts, and then a large portion of them write back to the default account. So we end up having to constantly make adjustments in GP so that each locations inventory and sales figures are correct.
The kicker is, when I run the orders through our test environment, into ASCs test environment, back into GP test, everything works exactly as it should, and from what I can tell everything is set-up exactly the same in the two systems. S my thoughts are that either, there is some ther spot or field, or set-up screen that I am unaware of that needs to be corrected, or it has to do with how the EDI orders are coming through initially, considering that when we do a test we manually enter the order. The only reason why that doesn't seem like the problem to me is, when I look at the final posted invoice that has the incorrect distribution accounts, the Site ID on the order is correct.
I hope that makes sense and that there is anyone out there who has had even something similar that can point me in the right direction.
All responses (
Answers (
601
