> For the complete documentation index, see [llms.txt](https://manual.unosofbooks.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://manual.unosofbooks.com/reports/accounting-reports/compare-reports-for-multi-app-companies/accounting-cases-compare-invoices.md).

# 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. 

<figure><img src="/files/Bgpxi4YPcNt3GAiButgx" 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="/files/gslb8c8SHBuIeRbyJ2tu" 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="/files/JQjAYg6yVnxkFZaXKGPt" 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="/files/wiGLCkCEamZyhCTXPzsY" 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="/files/8HkhP2QkYxd4isb0YSlF" 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="/files/WxZewnKJtN9uAiWVgqvW" 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="/pages/-M-VXsPnW2Ki2E2urs9m" %}
[Email Multiple Invoices](/customers/customer-service/email-multiple-invoices.md)
{% endcontent-ref %}

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

<figure><img src="/files/oPqcTSdX5qNlI9gtLmaG" 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="/files/Zt6ycsxxUqQGDr1YJwaW" 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 ](/files/-M0cRa5ctHb_9DRX1db7)

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="/files/OnPiBQAh92nStuST6lGw" 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="/files/q0V34l4IlVWQ9wxaZu19" 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="/files/HBp8yamMZTAwrxEcsaEB" 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="/files/kJFMRVww8ht6U0V90cHd" 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="/files/n3seEc20fxh5eVJOFOjI" 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 %}