# Accounting cases / Compare Invoices

## Differences Pending invoices vs Deposit page

When you work with a master server structure, our **deposit page** makes a remote call to the connected applications, such as the farm or the trading company.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FFSzI8HrDyrJiiJYboR5r%2Fimage.png?alt=media&#x26;token=bf633f6e-b2cd-4a4b-8524-3a231669d097" alt=""><figcaption></figcaption></figure>

However, the balances of the accounts in **accounting reports**, where you find the pending invoices/outstanding invoices, do not make a remote call to the connected applications, such as the farm or trading company.

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FvQRG0fVEg73JDtXQCUEB%2Fimage.png?alt=media&#x26;token=b236a14f-381a-4745-813b-8945bf803ca6" alt=""><figcaption></figcaption></figure>

It's possible that you have an outstanding balance in the accounting report, but that the amount is not showing up on the deposit page. This can mean:

* Un-invoiced POs in Farm or Trading Apps
* POs never loaded in Farm or Trading Apps

The invoicing process for Multi app companies may get affected by internet time-outs, causing un-invoiced POs, not synched POs, and differences in values, for example. The following sections document how to identify and solve these specific cases.&#x20;

## Un-invoiced POs in Trading

### How do I identify them?

You can check different ways to identify them. Here, we explain three.&#x20;

#### 1. Search Purchase Orders

Log in to the trading app you want to revise and follow the next steps:

{% hint style="success" %}
**Go to**: Customers/ Sales/ **Search Purchase Orders**
{% endhint %}

Please, make use of the following filters:

**Start Date** and **End Date**: Select a search range of time.

**Invoiced?**: Set this filter to **Not Invoice**&#x20;

Then, make sure the option **Purchase Order Results** option is selected and press the **SEARCH** button.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FkGSvTbgbwrMA9RPZQERX%2Fimage.png?alt=media&#x26;token=c812feaf-67d3-4b11-9adf-7578da4601b3" alt=""><figcaption><p>Use the correct filters</p></figcaption></figure>

It will load all the POs without an invoice. You can identify them by the text **N/A** in the column **Invoice** which means the PO does not have an invoice ID.

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2Fsz3tdoV9KgmqNDpXZuf6%2Fimage.png?alt=media&#x26;token=a3c547c9-123c-4116-a2d5-a1e85b327947" alt=""><figcaption></figcaption></figure>

#### 2. Compare Master/Trading Totals Reports

To review this report you need to log in to the master application.&#x20;

{% hint style="success" %}
Go to: Reports/ **Accounting Reports**
{% endhint %}

Please, select the report **Compare Trading** option from the drop-down menu located on the left side of the page.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FRbf7p2bQ8AXwxaJsq5YI%2Fimage.png?alt=media&#x26;token=37d893da-59ef-4214-a0a9-3201ec7c8889" alt=""><figcaption></figcaption></figure>

Use the date filters to set a search range and click on the **Generate Report** button. It will show all the POs created during that search range.

Please, locate the column **Trading Invoice**, PO without an invoice ID will appear as marked.

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2Feppa6W0ARisvzrhzFT1o%2Fimage.png?alt=media&#x26;token=665e3c21-cd9b-4bb4-8404-fb417464422e" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}

1. You can invoice your PO by rolling back the PO in master and invoice again. This reinvoicing process will fire the script again.&#x20;
2. The PO can be invoiced from the PO page of that specific PO by pressing the Create Invoice button.
   {% endhint %}

{% hint style="danger" %}
Please, contact the Unosof team in case you cannot roll back your PO in master or invoice the PO directly.
{% endhint %}

#### 3. Email Multiple Invoices

Another way to check these cases is the visualization of the module used to send invoices to the client.&#x20;

{% content-ref url="../../../customers/customer-service/email-multiple-invoices" %}
[email-multiple-invoices](https://manual.unosofbooks.com/customers/customer-service/email-multiple-invoices)
{% endcontent-ref %}

Entries shown in grey with the message **INVOICE NOT UPLOADED/PDF NOT GENERATED** warn you about un-invoiced POs.

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2F1UBFLhdJGaFm5E1ZFtu1%2Fimage.png?alt=media&#x26;token=62a9dc9c-2ff6-436b-944f-05fd4b473675" alt=""><figcaption></figcaption></figure>

## POs never loaded in Trading Apps

### How to identify them

{% hint style="success" %}
**Go to:** Reports/ **Accounting Reports**
{% endhint %}

Please, select the report **Compare Trading** or **Compare NAT Trading** option from the drop-down menu located on the left side of the page. Then, click on the green **Generate Report** button.

It will display all PO created during a range of time. POs never loaded to Trading Apps in the invoicing process appear highlighted in red.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2F3DQhlMsjcizyk36gJTYl%2Fimage.png?alt=media&#x26;token=7ada242a-d543-400b-9dca-98261b18e837" alt=""><figcaption><p>Red entries mean PO is not loaded in trading apps</p></figcaption></figure>

{% hint style="danger" %}
Please, contact the UNOSOF team for these types of cases. They would proceed to synchronize the POs.
{% endhint %}

## How to solve them?

{% hint style="info" %}
Tip: You can execute these steps directly in your browser, or followup them up in a notepad file.
{% endhint %}

Go to the PO page of the specific invoice by opening the order that does not appear on the make deposit page. Then, identify your GU\_Purchase Order ID in the URL link.

![PO Page, identify the GU\_Purchase Order ID ](https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M-BV4YRkYBYw5A4UAJL%2F-M0cPh0hPRZ8zkuuy75v%2F-M0cRa5ctHb_9DRX1db7%2FScreen%20Shot%202020-02-21%20at%2010.49.19%20AM.png?alt=media\&token=760d8fcd-a344-4835-b752-fa5f3685f4d5)

Once you have identified the GU\_purchase order ID, paste that somewhere temporarily. **E873472CCEB248C79DB1BC8FFAEC8700**

Click now in the browser or notepad, and type after the **.com** the following text[: **/index.cfm?event=purchaseOrder.generateInvoice\&gu\_purchaseorder=**](https://ecuanros1.unosof.com/index.cfm?event=purchaseOrder.generateInvoice\&gu_purchaseorder=2D4C77B0C63AE250F53A30C87B5B3EC8\&returnEvent=Invoices.Form)

Your link would look as follows:\
&#x20;[**https://test.unosof.com**](https://agrinag.unosof.com/index.cfm?event=synchProductsAGN\&gu_purchaseorder=BD8EF15B98D45859EE49C917A2787A27)[**/index.cfm?event=purchaseOrder.generateInvoice\&gu\_purchaseorder=**](https://ecuanros1.unosof.com/index.cfm?event=purchaseOrder.generateInvoice\&gu_purchaseorder=2D4C77B0C63AE250F53A30C87B5B3EC8\&returnEvent=Invoices.Form)

Paste the GU\_purchase order ID after the =\
your link would look as follows:\
&#x20;[**https://test.unosof.com**](https://agrinag.unosof.com/index.cfm?event=synchProductsAGN\&gu_purchaseorder=BD8EF15B98D45859EE49C917A2787A27)[**/index.cfm?event=purchaseOrder.generateInvoice\&gu\_purchaseorder=**](https://ecuanros1.unosof.com/index.cfm?event=purchaseOrder.generateInvoice\&gu_purchaseorder=2D4C77B0C63AE250F53A30C87B5B3EC8\&returnEvent=Invoices.Form)**E873472CCEB248C79DB1BC8FFAEC8700**

Paste the following text: [**\&returnEvent=Invoices.Form**](https://ecuanros1.unosof.com/index.cfm?event=purchaseOrder.generateInvoice\&gu_purchaseorder=2D4C77B0C63AE250F53A30C87B5B3EC8\&returnEvent=Invoices.Form) after the GU\_ID: **E873472CCEB248C79DB1BC8FFAEC8700**\
your link would look as follows:\
[**https://test.unosof.com**](https://agrinag.unosof.com/index.cfm?event=synchProductsAGN\&gu_purchaseorder=BD8EF15B98D45859EE49C917A2787A27)[**/index.cfm?event=purchaseOrder.generateInvoice\&gu\_purchaseorder=**](https://ecuanros1.unosof.com/index.cfm?event=purchaseOrder.generateInvoice\&gu_purchaseorder=2D4C77B0C63AE250F53A30C87B5B3EC8\&returnEvent=Invoices.Form)**E873472CCEB248C79DB1BC8FFAEC8700**[**\&returnEvent=Invoices.Form**](https://ecuanros1.unosof.com/index.cfm?event=purchaseOrder.generateInvoice\&gu_purchaseorder=2D4C77B0C63AE250F53A30C87B5B3EC8\&returnEvent=Invoices.Form)

Run the link, this shall fire a script that we re-invoice the PO and make a new remote call to the farm or trading to push in the PO and Invoice.&#x20;

{% hint style="success" %}
If you did these 6 steps correctly, you successfully solved the problem and the outstanding invoice amount shall be matching with the deposit page.&#x20;
{% endhint %}

## Differences in Tradings vs Master Apps

### How to identify them

{% hint style="success" %}
**Go to:** Reports/ **Accounting Reports**&#x20;
{% endhint %}

### **Method 1. Compare Master/Trading Totals**

Please, select the report **Compare Master/Trading Totals** option from the drop-down menu located on the left side of the page. Then, click on the green **Generate Report** button.

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FFf7n3V89bfMIFV3r6ih5%2Fimage.png?alt=media&#x26;token=d5997b93-4cff-4eaf-8e94-77853ccebaba" alt=""><figcaption></figcaption></figure>

It will display all PO created during a range of time. Please, focus on the following columns:

* **DIFF.** : Show the difference in USD between the Master and the Trading app. <br>
* **DIFF2**: Show differences in Stems between the Master and the Trading app.&#x20;

{% hint style="warning" %}
**Negative** values mean that the USD or Stem values in Trading are lower than in the Master. \
**Positive** values mean the USD Stem values are higher in Trading than in the Master. &#x20;
{% endhint %}

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FdSs4QUzQzSyFJLmSUZGx%2Fimage.png?alt=media&#x26;token=a7ac6397-e384-4285-b045-c5d164a6ba0c" alt=""><figcaption></figcaption></figure>

### Method 2. Compare Trading Values

Please, select the report **Compare Trading Values** option from the drop-down menu located on the left side of the page. Use the filters for dates to search for a specific time range.

Then, click on the green **Generate Report** button.

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2F4JGjIaYodpNyYMQhU74r%2Fimage.png?alt=media&#x26;token=9dd7c5cf-f87e-4109-a200-214bb5acd7c4" alt=""><figcaption></figcaption></figure>

The report displays invoices with differences in USD and stems values only between Master and Trading. See the following picture to have a better idea of how to recognize the differences between Master and Trading apps. Focus and compare the columns **Master Amount** against the column **Trading Amount**, and do the same thing with the columns **Master Stems** and **Trading Stems.**&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2F7D3kDHs22qHT2Uopm0lF%2Fimage.png?alt=media&#x26;token=16cc7329-9049-4848-8645-f8c537ace156" alt=""><figcaption></figcaption></figure>

Note in the example below the value in the trading app is lower than the master.&#x20;

{% hint style="success" %}
**Solution**: Roll back and delete the POs in the trading company and refire the invoice script from the master. This process will balance up the values between the master and trading.&#x20;
{% endhint %}

Go to the [invoice script](#how-to-solve-them) to refire the invoicing process.

## Differences in Master vs Farm apps

### How to Identify them

{% hint style="success" %}
**Go to:** Reports/ **Accounting Reports**  in the master app.
{% endhint %}

#### Compare ECN Invoice %

Please, select the report **Compare Compare ECN %** option from the drop-down menu on the left side of the page. Then, click on the green **Generate Report** button.

Locate the column % and check if there is any invoice with values on the farm level that exceed the master value.

{% hint style="info" %}
**Hint**: Make one click on the header to reorder from lowest to highest, and a second click to order from highest to lowest.
{% endhint %}

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FP26sxClV7IMOg6xAMS8N%2Fimage.png?alt=media&#x26;token=773db3cc-4a89-4ea6-ac07-47499b26f159" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}
**Solution**: In case, the farm invoice with the difference is authorized, please, contact the UNOSOF team for further investigation.
{% endhint %}
