Sage 300 E-invoicing Malaysia Module - PU3 - Audit table

2 minute read time.

In Sage 300 EI module PU3, there is a EIOAUD table which contain the audit trail of the E-invoice transaction.

In EIODOC table, we can find out the current status of the invoice. However, if user perform refresh/send in EI Outgoing processing screen, there will be status change of the invoice. In EIOAUD table, we are able to trace the status change.

To explain, i will start with create and posting an invoice. After posting the invoice in AR Invoice with invoice number TEST0211, below is the result of the EIOAUD table where IDINVC='TEST0211' which is the invoice number.

Take note of the SEQUENCE , PPLTRANS, PPLSTATUS and PPLAPSTT column. SEQUENCE means it's the very initial status of the invoice, it usually is right after the invoice is being posted in their respective module and generated into EI module.

Go to EI Outgoing processing screen, select the invoice and send it. Below is the results of the query after i have send the invoice. Notice an additional row is created with SEQUENCE = 2. PPLTRANS , PPLSTATUS, PPLAPSTT ,PPLDATE1,PPLTIME1 are changed, i can understand that the invoice is being Sent and i am able to find out this action is done by who and when based on the AUDTDATE/AUDTTIME and AUDTUSER.

I perform refresh in EI Outgoing processing screen to see if there is any changes on the status for the invoice , and if there is, there will be additional audit trail being logged for that invoice. if the invoice status remain unchanged after the refresh, there will be no new audit trail for that invoice.

The invoice in my example have a status change, thus there is a new sequence created.

At this point, my invoice is still pending response from LHDN, thus the PPLAPSTT= 15.

I wait a few minutes and refresh again, the invoice is being rejected by LHDN. Notice that PPLAPSTT column = 16, which mean the status is rejected by LHDN.

If user re-select the invoice and send again, what would happen to the audit trail ? Let's take a look at below.

Firstly, i resubmit the invoice.

Then we look at the EIOAUD table. Here we can see that the audit trail is still ongoing. You may observe that there is a new PPLTRANS value, and PPLAPSTT has become 1 which is 'Sent' status.

Here we can understand that user has resend the invoice, thus there is a new submission ID being issued due to a new PPLTRANS value.

---

Conclusion :

That's all from my example. This audit trail is beneficial for partner / customer to investigate on what user have done on the E-invoice transaction which may help on trobleshooting/investigating.