Hello! We have a number of transactions that are copied & pasted into Transaction Entry for ease of journal creation. I am very new to GP Dynamics & have a question about the proper setup of the Reference description & the GL Number for pasting into GP. Also, what is the purpose of such setup? For example, in Excel we have several hundred rows of data in the format:
Reference GLNumber Debit Credit
100 - 2/1/2021 1100-000-00 100.00 0.00
105 - 2/1/2021 1102-105-00 100.00 0.00
110 - 2/1/2021 1103-110-00 100.00 0.00
The pattern of this inherited setup seems to be that the beginning 3-digit figure matches the middle 3-digit figure of the GLNumber for each entry. I have created similar Excel data for other transactions but I have not conformed to this matching of 3-digit sections. What is the purpose of this matching? Reporting or something else? Am I creating problems by not having this matching in my other Excel data which I use to make quick & easy JE's? For example, I simply use 100 - 2/1/2021 in front of each data row instead of matching each with the 3-digit dept of the related GLNumber.
Thank you.
