Item ID Setups In Process Logic

  • 1
  • Question
  • Updated 3 years ago
  • (Edited)
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

Good Afternoon,

One of our customers is running into issues processing his invoices because the item detail on the invoice does not match that on the PO. Here is one example:

PO 1016019685

##########,1016019685,LI,10,2204228,820011,030907051256
##########,1016019685,LI,20,2204244,820010,030907051249
##########,1016019685,LI,30,2204286,0820021,030907063211
##########,1016019685,LI,40,2204294,840001,030907056749

Invoice 5119312

##########,5119312,LI,1,,0820011,030907062092,,,,,,,,,,,030907062092,
##########,5119312,LI,1,,0820010,030907062085,,,,,,,,,,,030907062085,
##########,5119312,LI,30,2204286,0820021,030907063211,,,,,,,,,,,030907063211,
##########,5119312,LI,40,2204294,840001,030907056749,,,,,,,,,,,030907056756,

Please note that the first two item records of the invoice are missing the buyer SKU in the fifth position of the LI record. The UPCs in the seventh record are also mismatches for these two items.

It appears that the customer needs to update his item information in the adapter. Where is this information stored?

Thanks!

Tim
Photo of Tim Smith

Tim Smith

  • 130 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Mai Yang

Mai Yang, Partner

  • 200 Points 100 badge 2x thumb

Hi Tim,

Did the PO import correctly with no errors?  It looks like there could be another issue as the first 2 LI records for the Invoice indicate a Line number of 1 for each line.

Typically the Customer Item Maintenance window is used to enter the buyer's SKU.  Cards>>Sales>>Customer Items.  Enter in the Customer ID and Item Number and then Enter a value in the Customer Item field to represent the buyer's SKU.

The Item's UPC Code can be entered using the EDI Information window at the Item Card level.  Cards>>Inventory>>Item.  Enter in an Item Number and then click on Additional>>EDI Information.  Enter the value in the Item UPC Code field.

Photo of Mic Kenney

Mic Kenney

  • 210 Points 100 badge 2x thumb

Mai,

I looked sin Gp table sop60300 and there are no records set up in there to reflect a correlation between our item number and the customers sku...I am therefore at a loss as to how the sku code is appearing on the L1 lines of the invoices at all, yet the sku code appears there many times...does Process Logic move the sku from the po to the invoice?


Photo of Mai Yang

Mai Yang, Partner

  • 200 Points 100 badge 2x thumb

Check the JSOP131 table for the UPC code values that are being sent for the L1 lines of the invoices.

Photo of Mic Kenney

Mic Kenney

  • 210 Points 100 badge 2x thumb
I looked at JSOP131 and it only has our item number and our UPC code..there is no correlation in this file for a customer's sku to relate to our items....somewhere Process Logic has to be  putting the customer's sku from the po into the invoice
Photo of Mai Yang

Mai Yang, Partner

  • 200 Points 100 badge 2x thumb

Ok - I think we need to take a step back.  Were there any errors when this PO was imported and created as a SO?  If yes, what were the errors and what steps were taken to fix them? 

Process Logic will return the customer's sku number that was sent in the PO for the LI record of an invoice.  So if errors occurred when this SO was created, it would explain why those lines are missing the customer sku's.

Photo of Mic Kenney

Mic Kenney

  • 210 Points 100 badge 2x thumb
I will have to review the order with the order entry gals...and will then let you know..thanks

This conversation is no longer open for comments or replies.