Qube Apps Solutions Sdn Bhd

Question: This Receipt is printing "Pending" at the below, please help me to check the E-Invoice Status from your end.

================================================================

Solution:

1) What is the Receipt Date for the Receipt want us to check?

Where CASHIERX is the counter number you specify for search the specific receipt number.

2) Go to "EINVOICE_TRANSACTIONS" table, check the Transaction No (With the Format "Store Code-Cashier Terminal No-Transaction Number")

Example here is "B060-T3-223842"

3) Find the "STATUS" Column. To see the current E-Invoice Status. 
If Valid. Then post the screenshot for Transaction Number and E-Invoice Status into the ticket reply. 
 
4) If other than Valid status (Such as Invalid / Rejected). There is the "NOTE1" Column to show the root cause. 

=========================================================================

For 1 Receipt: The Buyer's Information will be shown on top of the receipt, like example below:


1) Check the Respective Receipt Number From the Bottom part of the E-Invoice, or remember the Counter number and Receipt Number

2) Open the SQL Explorer, Access the Path:

Main Path:
CASHIER1:D:\QASDEV\QUBEV10\BACKEND\DB\EINVOICE.FDB

Or Individual Cashier's FPOS -> EINVOICE.FDB path:
CASHIER1:D:\QASDEV\QUBEV10\BACKEND\DB\EINVOICE.FDB
CASHIER2:D:\QASDEV\QUBEV10\BACKEND\DB\EINVOICE.FDB
CASHIER3:D:\QASDEV\QUBEV10\BACKEND\DB\EINVOICE.FDB

AND SO-ON SO FORTH

3) Access the "EINVOICE_TRANSACTIONS" table,

Search the transactions number. Find the "NOTE1" Column.

If got error, it will show some words within this column.

2) Go to Buyer Table, Edit the buyer information according to the Error message shown in NOTE 1.

NOTE 1 ERROR MESSAGE	Can Directly Check From Receipt ?	SOLUTION
Enter Valid Phone Number - Buyer		Make Sure Phone Number Format is like this ONLY: "0123456789" OR "+60123456789"
Enter Valid Email Address - Buyer		Make Sure Email Address do not have space or comma "," inside the email: Example: Cannot like "einvoice@mr diy.com.my" After remove the space inside the email column. Example will be like: "einvoice@mrdiy.com.my"
STEP04 - Invalid Code Field Validator		Make Sure State Code Column Cannot put "00" (All States) Follow this table from LHDN: State Codes
Postcode Maximum length is 5 characters - Buyer		Check Postcode should be something like "46200", not "462000"
Enter Valid Phone Number and the maximum length is 20 Characters - Buyer		1) Phone number cannot blank. Need to insert data. 2) Only 1 Phone Number can fill in.
Step05-Invalid Taxpayer Profile Validator		Change the Reg. No For Customer Company: 1) From Old Format to New Format 2) Remove the Old Format (If customer include both New and Old Format together)
Issuance date time value of the document is too old that cannot be submitted.	Cannot find information from receipt.	Check the "Created_AT Date" Column, if it's within the current month / date. Update the WebApiAcctLinkAgent.exe version and WebApiAcctLinkAgent.pdb Can get from our domestic team support if don't have.

3) Access the "BUYERS" table, Edit the customer info into correct format based on your scenario you followed above.

ID_NO -> Edit Business Reg.No (BRN)
TELEPHONE -> Edit Phone Number
EMAIL -> Edit Email Format
POSTAL_ZONE -> Edit Postcode
COUNTRY_SUBENTITY_CODE -> Edit Country State Code (Eg: "00" Change to "10")
COUNTRY_SUBENTITY_NAME-> Edit Country State Name (Eg: "All State" Change to "Selangor")

4) Access the "EINVOICE_TRANSACTIONS" table, Change status "REJECTED" to "PENDING" (Make sure previous month data don't have PENDING else change to REJECTED)

5) Change EXPORTED column from "T" to "F"

6) Copy WebApiAcctLinkAgent_Backend to update latest version

7) RunEInvoice_1_ResendPending.bat

8) RunEInvoice_2_GetDocStatus.bat

9) RunEInvoice_3_Sync.bat