Problem

Function Post All Document is development for CNA for allow user post Sales Shipment, Purchase Receipt, Sales Invoice and Purchase Invoice by clicking one action button.

However, the positing problem is occurred occasionally and not able reproduce.   The error is the positing process is stopped but not all document is completed. 

For example, Shipment is posted but system return there is nothing post to PI or SI.  In this case, the shipment and receipt have been posted and PI header is created but PI line is not created by system.

Before the root of problem is find and resolved, manual procedure for complete the SI, PI and positing is needs.

Solution

Case 1 - Problem reported by user at Oct 16, 2020 (JIRA-247)

Error Message: The record in table G/L Entry already exist.  Identification fields and values: Entry No. = 144991

p.s. GL Entry 144991 is not related to the group shipment invoice

1) Manually go to Sales Invoice, Post Sales Invoice PHW20060019G

2) Go to "Group Shipment Header" table, change "Posting Status" to "Shipped+PI+SI"

3) User can continue posting in Group Shipment screen


Case 2 - Problem reported by user at Oct 22, 2020 (JIRA-248)

Error Message:  Purchase Invoice Nothing to Create

Work around for post the group shipment

1) set no. series for sales invoice allow Manual

2) Open the PI, get Receipt Line than Post

3) Create SI, get Shipment Line then Post

4) Patch Group Shipment Header - posting status and Posted SI No

5) Patch Group Shipment Line - Purchase Invoice No

6) Patch Posted Sales Invoice Header - replace the SI no generate by system by Group Shipment Sales Invoice No 

7) un-select manual number series for sales invoice


Case 3 - Problem reported by user at Feb 3, 2021 (JIRA-264)

Error Message:  The record in table Purchase Header already exist.  Identification fields and values: Document Type = "Invoice". No. = 9110001697

Manual Posting Step as below:

  1. Re-open the Closed SO
  2. Re-open Released PO
  3. Data Patch for PO Quantity – Change Qty from 199.81 to 199.811 for the over receipt Qty
  4. Show the Document Date and Posting Date field in Purchase Order
  5. Enter Document Date and Posting Date in PO (refer to Group Shipment, both Document Date and Posting Date is Feb 1, 2021)
  6. Check Qty to Receipt – refer to Group Shipment Qty To Receipt to be 107.59
  7. Post PO Receipt
  8. Close SO
  9. Edit No. Series to allow manual enter the Sales Invoice No,
  10. Create Sales Invoice
  • Change Document Date, Posting Date and Due Date (refer to Group Shipment)
  • Get Shipment Line
  • Check Line Dimension, make sure SO No is populated to the line dimension
  • Salesperson – I remember that the SI Sales to be according to Customer Master
  • Post Sales Invoice

11. Open the purchase invoice 

  • Check Document Date, Posting Date and Due Date (refer to Group Shipment)
  • Get Receipt Line to Post
  • Due to standard function is not allow change Line Amount, add line for the 0.04 variance

12. Post Purchase Invoice

13. Patch Group Shipment Header for Positing Status and Posted SI No

14. Patch Group Shipment Line for Posted PI No.


Case 4 - Problem reported by user at Jun 16, 2021 (JIRA-269)

Error message “no purchase invoice is created” had been prompted when he posted the invoice.

User press Post All Document again after confirmed the message.  Another error related to permission prompted.

Workaround for post the document.

  1. Go to no. series and set allow manual number for “S-INVBV”
  2. Create new Sales Invoice, enter the SI No, and Posting No manually (i.e. 13228235)
  3. Enter Customer name and change the currency code to USD
  4. Go to line tab – select function=> get shipment line (p.s. Shipment for the GS have been posted successfully, so user can get the shipment line accordingly)
  5. Check the header and line dimension, posting date, document date and due date for make sure it match with related group shipment invoice.
  6. Go to purchase invoice, you can see PI NO 13228235 have been created but no details
  7. Go to line tab – select function => get receipt line (p.s. Receipt for the group shipment have been posted successfully)
  8. Check the header and line dimension, posting date, document date and due date for make sure it match with related group shipment invoice.
  9. Preview Posting then post the PI if the entries is expected
  10. Preview Posting then post the SI if the entries is expected
  11. Go to no, series and un-select allow manual number for S-INVBV
  12. Notify me after post, I will patch the Group Shipment Posting Status and related PI/SI no to the GS record.


Case 5 - Incomplete Posting Process (CNANAVHK-14, CNANAVHK-19)

In this case, system may be only post the Shipment and Receipt then PI is created but not post.  In Group Shipment Status is "Shipped" only. 

Follow the steps below for fix the problem. 

  1. Go to the Sales Order and Purchase Order to check if the Shipment and Receipt are posted respectively,

  2. Go to no. series and set allow manual number for “S-INVBV”

  3. Create new Sales Invoice, enter the SI No, and Posting No manually (e.g. the Group Shipment Invoice No it entered by user)

  4. Enter Customer name and change the currency code to USD

  5. Go to line tab – select function=> get shipment line (p.s. Shipment for the GS have been posted successfully, so user can get the shipment line accordingly)

  6. Check the header and line dimension, posting date, document date and due date for make sure it match with related group shipment invoice.

  7. Go to purchase invoice, you can see PI of the GS have been created but no details

  8. Go to line tab – select function => get receipt line (p.s. Receipt for the group shipment have been posted successfully)

  9. Check the header and line dimension, posting date, document date and due date for make sure it match with related group shipment invoice.

  10. Ask user to Preview Posting then post the PI if the entries is expected

  11. Ask user to Preview Posting then post the SI if the entries is expected

  12. Ask user to notify us after post

    1. Go to no, series and un-select allow manual number for S-INVBV

    2. Patch the Group Shipment Posting Status and related PI/SI no to the GS record.   *Status and Posted SI No. => Header ; Posted PI No => Line (PI No)