Company: Link Technologies
Case No: L12498
Logged By: Sanjay (Link Technologies) on 22 Sep 2015 08:17PM
Priority: Not Applicable
Product: Other
Group: To be assigned
Time Taken: 0.00
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay
Resolve By: Tuesday, 22 September 2015 08:17 PM [3111 days since logged date]
Status: Closed
Subject: Jiwa and Point of Sale (POS) Reconciliation Report
Summary:    

The purpose of this post is to explain how users can reconcile differences between JIWA Transactions and Link Point of Sales Transactions.

When transactions are created in Link Point of Sales, these transactions flow into JIWA as sales orders and Credit Returns. Transactions in JIWA Needs to be posted. Once these transactions are posted, the reconciliation report can identify if there are any differences between the two systems,

The first page of the report will give a summary of transactions in JIWA and POS.
Drill down into transactions to view details of JIWA and POS transaction numbers and values.

Some causes of differences are:

  1. Jiwa Sales Order is manually changed, removed or added before activating the sales order
  2. Jiwa Credit Return is changed, removed or added before activating the Credit Return
  3. Payment details are changed in JIWA before activating the Payment
  4. Transaction created in POS flows into JIWA and is not posted in JIWA
  5. Transaction created in POS flows into JIWA and is changed before posting
  6. Transaction in POS will not flow into JIWA if LINKSOFT inventory account code is not setup
  7. JIWA POS integration schedule is not correctly configured or disabled

The reconciliation report will identify these changes and allows the user to drill down to see what the exact differences are.

Once the issue in 4 and 5 above is resolved, transactions from POS will flow into JIWA
If the original sales order is processed, a new sales order will be created. The individual line variance will show in the drill down, however the summary totals will balance.

To access the report, log into the Link Reporting Tool. See Figure 1 below

Figure 1 - Log into Link Reporter

Check that you are connected to the correct server. You can check by pressing + Z at the same time. Figure 2 appears. Confirm that the server and Database details are correct.


Figure 2 - Database Configuration Details

Once logged in to reporter, choose the "POS JIWA Reconciliation by Period" report shown in figure 3 below

Figure 3 - POS Jiwa Reconciliation Report

Now generate the report. Figure 4 below shows the report layout.


Figure 4 - POS Jiwa Reconciliation Report Layout

Note the report shows a difference of $95.25. This difference is shown as the JIWA sales order has not been activated. You can drill down to the report details by double clicking on the difference line.

Once the transactions are posted in JIWA - This report should show ZERO difference.



Audit Notes:
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12498 in the subject line of all emails regarding this issue.

Document size: 300.8 KB
For call complaints, please contact the Managing Director of the company using this form