We added a new Dollar General DC (Bethel) and the item price does not import into GP

  • 1
  • Problem
  • Updated 4 years ago
  • Solved
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Old

Dollar General PO 203069. My company is BPG International.  When I import and create DG orders into GP, the pricing for the Bethel DC does not populate.  This is the most recent DC that we added since we fully integrated EDI.
Photo of Denise Borcky

Denise Borcky

  • 90 Points 75 badge 2x thumb

Posted 4 years ago

  • 1
Photo of FAQ

FAQ, SPS FAQ

  • 9,340 Points 5k badge 2x thumb

Up front let me state that I got on with Denise to take a look at this to see what was setup and what was happening and we have this resolved.  Here is the detailed information.

In GP you can setup prices by using Price Sheets or a Price List.  If you are using Price Sheets then the prices will come from the Price Sheet (all this assuming SOP Pricing not customer pricing on PO).  If you are using Price Lists then the price will come form the Price List.  Denise is using Price Sheets in her company. 

What we found was that the customer in question was setup exactly like similar customers that were working correctly.  Denise noticed one difference and it was a big one.  The new customer did not have a Currency defined (on the Custer Maintenance window).  Once we set the currency field up and re-created the PO, the prices populated correctly.  It appears that Process Logic, when using Price Sheets at least, gets the customers currency value and take the 'exchange rate' for that currency and multiplies it by the price value.  Since there was no currency ID the exchange rate was 0, so price X 0 = 0 resulting in the issue. 

If you are using Price Lists and this happens, check your pre-processing report to see if it calls out an error that the price sheet or method could not be found as well as the 0 price amount.  If this happens, pull up the customer card for that customer and ensure that not only the currency ID field is set but that the 'Price Level' field is set as well.  that Price Level is used to find the Price List to pull the price from. 

So in short, it is a good practice that when you create the Customer Maintenance records that you should set the Currency ID field and if you are using Price Lists, set the Price Level field as well. 

 Below is the 'Price Level' field if using Price Lists.

Below is the Currency ID (on the options window) field no matter if you are using Price Sheets or Price Lists.

Photo of Pam Schulz

Pam Schulz

  • 240 Points 100 badge 2x thumb
I just wanted to mention that we have the exact opposite affect when setting the Currency ID in Customer Maintenance.  We cannot set anything in that field or the EDI value will be blank.

Thanks,
Pam Schulz
Badger Basket
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Hi Pam,

Apologies for the late response!  Are you still experiencing issues with this?  I am looping in the team to see if they have any input.

Best,

Jordan

This conversation is no longer open for comments or replies.