Customer has inventory in another system, and populates GP POP. When receivings come in they also come in through the other system and are imported and posted. No actual inventory items reside in GP. They have many pricing differences from standard cost, but when they do the Enter/Match process to match the invoice to the receipt, it will not allow them to change the inventory account for the pricing difference. So, on each enter/match they have to manually edit the distributions with 2 'other' type lines to back the inventory account out and post it to the correct PPV account.
The vendors do not have a default PPV account set up, but I am not sure that would work anyway because they have multiple locations thay are tied to the GL so, they cannot default one GL account on a vendor since it may hit 9 different locations which would determine the first segment of the GL account string.
I looked at the site setup, but all of the importing only comes into MAIN so there would be no substitution there.
Customer said she would even prefer to have the GL line blank for PPV - if it cannot default by the location.
Does anyone have a clue as to how er can set this up to default a blank account for PPV or default a PPV by the location already in the rest of the distribution?
*This post is locked for comments
The inventory receipt (which is imported) typically debits Inventory, credits Received Not Invoiced, and, if there is a difference from Standard, a PPV account. However, since you have no inventory, the system cannot determine the valuation method of the item received, and treats it as a non-inventory item. Thus RNI and Inventory are hit.
During the matching, the RNI is reversed, the amount on the invoice is posted to payables, and, if there is a difference, again a ppv account is hit. Without sites, and receipts to sites, the site segment cannot be changed. In other words, why are you receiving everything to the site Main?
GP does not have default PPV accounts by site, only the ability to change certain accounts by the site segment. I do not believe that the PPV account is one of those. (inventory asset, sales, cost of goods sold, and returns)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156