hello users
i have two business, last year business and this year business. everything is the same. so i wanted to join last year business with the current year business. so i wanted to copy all payment and receipts from last year to this year by doing batch create.
so i opened the last year business and clicked batchupdate and clicked on copy to clipboard button and pasted to excel. when pasted, the column paidfrom did not contain cash account or bank account it just contain random numbers, i just left as it is and i opened this year business and went to payment as well and clicked on batch create. in paidfrom preview it contain random numbers seen in excel. when i clicked batch create all bank accounts and cash accounts were those numbers seen in excel as well.
First, you should not be creating new businesses for new accounting years. Manager is a perpetual program. See Close an accounting period | Manager.
Second, those “random numbers” are the GUIDs (Globally Unique Identifiers) for the accounts, used by the program to tell them apart. They are hexadecimal strings. And they must be generated by the program, not assigned by you. So, you cannot paste Batch Update data from one business filed into another’s Batch Create window without modification. You must use GUIDs from the destination business and/or allow the program to create them.
It appears you may not have the skills necessary to accomplish what you are trying to do. It is not an easy task. Nor is it likely to produce satisfactory results, because there are more general ledger entries than just receipts and payments that are necessary to combine two accounting periods. Some of those are created automatically by the program. You will probably end up with many, many transactions in Suspense, books out of balance, etc.
