When a journal is posted from AOI or a Standalone Journal, it goes into a temporary table where there is no validation on the number of decimal places and focuses on the values balancing, which will allow the journal to upload into the batch with multiple decimal places but may not post from the batch to the ledger.
We would recommend using the journal to 2 decimal places to be able to upload into the batch and post from Access Financials. You can use the aid of the round function to make sure the data is set to 2 decimal places.
In a large journal, you can also use the following formula in Excel to help identify any values that have more than two decimal places in them, replacing {cell} with the reference of the cell containing the number. This will return TRUE for any value in cell reference {cell} that has more than two decimal places:
=AND({cell}-INT({cell})<>0,INT(({cell}-INT({cell}))*100)=0)
Ensure you input the correct values before attempting to validate and process/upload the journal into Access Financials.
You can then delete the journal in the batch that would not load and post the new one instead.
Issues with decimal places in journal upload validation and posting from the batch to the ledger.
Updated over 3 months ago