SAGE: management table modeling
sara
-
nini -
nini -
Hello;
I have a project that involves developing an application that uses the database of the SAGE ERP (only the commercial management part).
To do this, I need to understand the structure of the commercial management database created automatically by Sage on SQL Server.
I have Sage's documentation, but it doesn't explain well the tables and their relationships. Because I want to create a modeling of the commercial management tables in Sage.
Thank you very much+++
:?: :?: :?:
I have a project that involves developing an application that uses the database of the SAGE ERP (only the commercial management part).
To do this, I need to understand the structure of the commercial management database created automatically by Sage on SQL Server.
I have Sage's documentation, but it doesn't explain well the tables and their relationships. Because I want to create a modeling of the commercial management tables in Sage.
Thank you very much+++
:?: :?: :?:
Configuration: Windows 2000 Firefox 1.5.0.5
14 réponses
1) I am currently researching the documentation to provide you with the correct fields.
2) ACCOUNT BALANCE:
---------------------
When an invoice is issued and recorded, the client owes the total amount including tax.
Therefore, this amount is recorded as a debit in account 411xxxx.
Payment can be processed in 2 ways:
a) When a payment by check or bank transfer arrives, the client’s account is credited with the amount. If the amounts match between the invoice and the payment, the accounting department performs a “matching,” meaning they associate both accounting entries with the same letter. This indicates that the invoice is no longer due.
b) If the payment arrives in the form of a draft (LCR) or a promissory note (BOR), it is nothing more than a promise to pay the amount stated on this document (LCR/BOR) within 30 or 60 days. It is in no way “actual cash.” If the client is a trustworthy business, bankers will probably agree to “advance” the amount of this LCR/BOR, subject to interest fees. This is known as “discounting a draft.” Otherwise, the deadline must be waited - 15 days to present it to the bank, hoping it will be honored by the client. The complete accounting treatment for the draft is as follows:
- the draft “in portfolio” is recorded in account 413xxxx (the LCR is in the folder pending)
- the draft submitted to the bank “at maturity” or “for discounting” is recorded in account 511xxxx (the LCR is at the bank, but we have not received the money).
- once the draft is settled and the money is in the account, it is recorded in account 512xxxx.
Often, businesses skip the step of account 511xxxx. Therefore, it is necessary to determine with the accounting department at what point the LCR/BOR is considered to settle the invoice and thus releases the outstanding balance.
In every scenario, you must consider that unmatched invoices are to be included in the outstanding balance.
The accounting outstanding balance for each third party would read:
“SELECT SUM(EC_Montant*((EC_Sens)*2)-1)) FROM F_ECRITUREC WHERE EC_Lettrage = 0 GROUP BY CT_Num”
Be careful to limit the search to the current fiscal year only, since matched entries from the previous year (N-1) are included in the “Carried Forward” of the current year (N).
Here is some “food for thought” for the accounting scheme of payments.
Wow! It’s been a while since I’ve done a class like this!
See you!
Phil
2) ACCOUNT BALANCE:
---------------------
When an invoice is issued and recorded, the client owes the total amount including tax.
Therefore, this amount is recorded as a debit in account 411xxxx.
Payment can be processed in 2 ways:
a) When a payment by check or bank transfer arrives, the client’s account is credited with the amount. If the amounts match between the invoice and the payment, the accounting department performs a “matching,” meaning they associate both accounting entries with the same letter. This indicates that the invoice is no longer due.
b) If the payment arrives in the form of a draft (LCR) or a promissory note (BOR), it is nothing more than a promise to pay the amount stated on this document (LCR/BOR) within 30 or 60 days. It is in no way “actual cash.” If the client is a trustworthy business, bankers will probably agree to “advance” the amount of this LCR/BOR, subject to interest fees. This is known as “discounting a draft.” Otherwise, the deadline must be waited - 15 days to present it to the bank, hoping it will be honored by the client. The complete accounting treatment for the draft is as follows:
- the draft “in portfolio” is recorded in account 413xxxx (the LCR is in the folder pending)
- the draft submitted to the bank “at maturity” or “for discounting” is recorded in account 511xxxx (the LCR is at the bank, but we have not received the money).
- once the draft is settled and the money is in the account, it is recorded in account 512xxxx.
Often, businesses skip the step of account 511xxxx. Therefore, it is necessary to determine with the accounting department at what point the LCR/BOR is considered to settle the invoice and thus releases the outstanding balance.
In every scenario, you must consider that unmatched invoices are to be included in the outstanding balance.
The accounting outstanding balance for each third party would read:
“SELECT SUM(EC_Montant*((EC_Sens)*2)-1)) FROM F_ECRITUREC WHERE EC_Lettrage = 0 GROUP BY CT_Num”
Be careful to limit the search to the current fiscal year only, since matched entries from the previous year (N-1) are included in the “Carried Forward” of the current year (N).
Here is some “food for thought” for the accounting scheme of payments.
Wow! It’s been a while since I’ve done a class like this!
See you!
Phil
Good evening Sara,
Can you confirm whether it is the ERP L1000 or just the management software L100?
If it's the L100 management software, then I can help you. Which part of the management software do you need?
Thank you for clarifying your project a bit; otherwise, it will take days to describe all the mechanisms and the associated tables.
For your information, the documentation on the structure of the L100 database can be downloaded from http://segs.free.fr
Talk soon
Phil
Can you confirm whether it is the ERP L1000 or just the management software L100?
If it's the L100 management software, then I can help you. Which part of the management software do you need?
Thank you for clarifying your project a bit; otherwise, it will take days to describe all the mechanisms and the associated tables.
For your information, the documentation on the structure of the L100 database can be downloaded from http://segs.free.fr
Talk soon
Phil
Hello Sara,
I understand your embarrassment. You are indeed tackling the most difficult information.
STOCKS
--------
The instant stock of items is a zone that follows the rules below :
1) future stock = actual stock + undelivered supplier orders - undelivered pending orders
(stock management is done by warehouse => in general, for each item, the warehouses need to be summed up)
2) if the items are managed by batch, a search and summation of the different batches must also be performed.
THIRD-PARTY RECEIVables
-----------------
The third-party receivables apply to clients and suppliers.
We need to talk about the accounting receivable.
1) The accounting receivable is defined by the unresolved commitment of a third party.
It therefore includes:
Commercial commitments:
* unbilled deliveries,
* orders accepted by the company
(10 orders of an average amount can greatly exceed the authorized receivable, even if each order is less than the balance)
The accounting balance:
* unpaid invoices
* unoffset payments
* promissory notes in account 413,
* promissory notes submitted to the bank not yet paid (discount or collection) in account 511
2) It is important to take all these elements into account: Accounting balance + Commercial commitments
3) Each solvency check (receivable control) in Sage is recalculated.
4) The receivable information in the third-party record is an authorized receivable
5) It is necessary to differentiate the "Authorized Receivable" from the "Credit Insurance Limit". The "Credit Insurance" is a risk taken on by a financial organization external to the company, which is a paid service. The receivable authorized by the company's management can be greater than or equal to the credit insurance. In this case, the risk assumed by the company is calculated as follows: Client receivable - Credit insurance = Risk incurred.
This is a start of an answer. I will find the tables and fields to manipulate in both cases.
Second intervention coming ASAP.
See you +
Phil
I understand your embarrassment. You are indeed tackling the most difficult information.
STOCKS
--------
The instant stock of items is a zone that follows the rules below :
1) future stock = actual stock + undelivered supplier orders - undelivered pending orders
(stock management is done by warehouse => in general, for each item, the warehouses need to be summed up)
2) if the items are managed by batch, a search and summation of the different batches must also be performed.
THIRD-PARTY RECEIVables
-----------------
The third-party receivables apply to clients and suppliers.
We need to talk about the accounting receivable.
1) The accounting receivable is defined by the unresolved commitment of a third party.
It therefore includes:
Commercial commitments:
* unbilled deliveries,
* orders accepted by the company
(10 orders of an average amount can greatly exceed the authorized receivable, even if each order is less than the balance)
The accounting balance:
* unpaid invoices
* unoffset payments
* promissory notes in account 413,
* promissory notes submitted to the bank not yet paid (discount or collection) in account 511
2) It is important to take all these elements into account: Accounting balance + Commercial commitments
3) Each solvency check (receivable control) in Sage is recalculated.
4) The receivable information in the third-party record is an authorized receivable
5) It is necessary to differentiate the "Authorized Receivable" from the "Credit Insurance Limit". The "Credit Insurance" is a risk taken on by a financial organization external to the company, which is a paid service. The receivable authorized by the company's management can be greater than or equal to the credit insurance. In this case, the risk assumed by the company is calculated as follows: Client receivable - Credit insurance = Risk incurred.
This is a start of an answer. I will find the tables and fields to manipulate in both cases.
Second intervention coming ASAP.
See you +
Phil
Hello;
I followed your discussion, it is interesting.
For me, I want to know if the accounting balance is the one displayed in the accounting when querying a third party?
Thank you.
I followed your discussion, it is interesting.
For me, I want to know if the accounting balance is the one displayed in the accounting when querying a third party?
Thank you.
Good evening al_mer,
Yes, absolutely, since the display of this accounting balance is the result of the query we built step by step with Sana.
Furthermore, changing from "Unmatched entries" to "Matched entries" at the bottom of the window restarts the query by modifying the parameter from "EC_Lettrage = 0" to "EC_Lettrage = 1" or "EC_Lettrage = 0 OR EC_Lettrage = 1".
See you later
Phil
Yes, absolutely, since the display of this accounting balance is the result of the query we built step by step with Sana.
Furthermore, changing from "Unmatched entries" to "Matched entries" at the bottom of the window restarts the query by modifying the parameter from "EC_Lettrage = 0" to "EC_Lettrage = 1" or "EC_Lettrage = 0 OR EC_Lettrage = 1".
See you later
Phil
I don't see a direct response in this request.
The solution could involve entering a due date for the OD:
- in the line for account 4110000
- in the counterpart as 413xxxx.
ex:
Date.............CpteG.......Tiers...................D............C...............Due Date
====...........====........===............==============.......========
20.04.07......4010000.....Toto............................|1196.00........20.05.07
20.04.07......4130005.....Toto...............1196.00|.....................20.05.07
To do this, the account(s) 413xxxx must be declared with the options:
- Due date entry
- Third-party entry
In this case, an additional element could be added in the WHERE clause by indicating
... AND GC_NUM = "4110000" AND EC_Echeance < '20070420'
for a deadline of the outstanding amount as of today, 20/04/07.
To be tested! I'm counting on you to let us know if this is coherent.
Thank you all.
Cheers
Phil
The solution could involve entering a due date for the OD:
- in the line for account 4110000
- in the counterpart as 413xxxx.
ex:
Date.............CpteG.......Tiers...................D............C...............Due Date
====...........====........===............==============.......========
20.04.07......4010000.....Toto............................|1196.00........20.05.07
20.04.07......4130005.....Toto...............1196.00|.....................20.05.07
To do this, the account(s) 413xxxx must be declared with the options:
- Due date entry
- Third-party entry
In this case, an additional element could be added in the WHERE clause by indicating
... AND GC_NUM = "4110000" AND EC_Echeance < '20070420'
for a deadline of the outstanding amount as of today, 20/04/07.
To be tested! I'm counting on you to let us know if this is coherent.
Thank you all.
Cheers
Phil
Hello Mr ppa;
Actually, I have two questions:
1) In the customer file under Sage, in the statistics tab:
-the total, which is the sum of the four lines that follow
* overdue by 1 month, 2 months, 3 months, and not overdue, I want to know what that reflects? Is it from the invoice date or from the payment due date?
2) To enter a payment, Sage does not provide the option to enter the due date of a bill of exchange, for example. How can we enter it?
Thank you very much.
Actually, I have two questions:
1) In the customer file under Sage, in the statistics tab:
-the total, which is the sum of the four lines that follow
* overdue by 1 month, 2 months, 3 months, and not overdue, I want to know what that reflects? Is it from the invoice date or from the payment due date?
2) To enter a payment, Sage does not provide the option to enter the due date of a bill of exchange, for example. How can we enter it?
Thank you very much.
Hello;
I want to know if the due date of a bill of exchange must be less than or equal to the due date of the invoice?
Please answer me
I want to know if the due date of a bill of exchange must be less than or equal to the due date of the invoice?
Please answer me
Hello,
In principle, and as a matter of courtesy, a payment must be made by the due date of the invoice at the latest.
On the other hand, a bill of exchange must be returned "accepted" within a maximum period of 8 days following its issuance date, which is the invoice generation date.
Even if the settlement date (LCR due date) is later (e.g., 60 days end of month), this allows the beneficiary company to discount it if cash flow needs require. The drawee will only be debited on the due date of the bill of exchange.
Phil
See you later
In principle, and as a matter of courtesy, a payment must be made by the due date of the invoice at the latest.
On the other hand, a bill of exchange must be returned "accepted" within a maximum period of 8 days following its issuance date, which is the invoice generation date.
Even if the settlement date (LCR due date) is later (e.g., 60 days end of month), this allows the beneficiary company to discount it if cash flow needs require. The drawee will only be debited on the due date of the bill of exchange.
Phil
See you later
Hello;
please, is it possible to associate an invoice with a LCR or BOR from the sales management system, even if they do not have the same general account?
please, is it possible to associate an invoice with a LCR or BOR from the sales management system, even if they do not have the same general account?
Hello,
The important thing is that the third-party account is the same (Invoice to client TOTO on account 411xxxx, bill of exchange from client TOTO on account 413xxxx).
However, it is possible that account 413xxxx is not auxiliary and therefore the reconciliation is still done. This is the case for a transfer or a check recorded directly in 512xxxx.
See you later
Phil
The important thing is that the third-party account is the same (Invoice to client TOTO on account 411xxxx, bill of exchange from client TOTO on account 413xxxx).
However, it is possible that account 413xxxx is not auxiliary and therefore the reconciliation is still done. This is the case for a transfer or a check recorded directly in 512xxxx.
See you later
Phil
Hello Sara,
A document in the gescom consists of 2 elements:
- a header in F_DOCENTETE
- document lines in F_DOCLIGNE
Therefore, it is necessary to modify the document type in each of the 2 tables (DO_Type, see the structure of line 100) to evolve the entire document to status BL.
BUT, attention! That's not all:
- it is necessary:
-> to search for the last document number BL and increment it
-> to indicate the date of the new document BL
-> to carry this information in the header and in all lines of the document
- it is also necessary to report:
-> the BC number in the field DL_PieceBC
-> the BC date in the field DL_DateBC
- Should we manage the leftovers? If so, it is necessary:
-> to duplicate the document header,
-> to modify the field DO_Reliquat
Conclusion, this is not 1 query, but a whole procedure to write.
Good luck
Phil
A document in the gescom consists of 2 elements:
- a header in F_DOCENTETE
- document lines in F_DOCLIGNE
Therefore, it is necessary to modify the document type in each of the 2 tables (DO_Type, see the structure of line 100) to evolve the entire document to status BL.
BUT, attention! That's not all:
- it is necessary:
-> to search for the last document number BL and increment it
-> to indicate the date of the new document BL
-> to carry this information in the header and in all lines of the document
- it is also necessary to report:
-> the BC number in the field DL_PieceBC
-> the BC date in the field DL_DateBC
- Should we manage the leftovers? If so, it is necessary:
-> to duplicate the document header,
-> to modify the field DO_Reliquat
Conclusion, this is not 1 query, but a whole procedure to write.
Good luck
Phil
Hello;
Please can you explain to me the role of the following tables in SAGE;
- F_FAMTARIF
- F_FAMCLIENT
Please can you explain to me the role of the following tables in SAGE;
- F_FAMTARIF
- F_FAMCLIENT
Good evening everyone,
I took advantage of some unavailability at work to respond to you almost in real-time these past few days. A colleague even stepped in sometimes to reply on my behalf with great skill.
However, I have a job and I no longer have as much availability. So I will answer your questions, but for now, please give me a little bit of time.
In any case, thank you for your interest in our exchanges.
Phil
I took advantage of some unavailability at work to respond to you almost in real-time these past few days. A colleague even stepped in sometimes to reply on my behalf with great skill.
However, I have a job and I no longer have as much availability. So I will answer your questions, but for now, please give me a little bit of time.
In any case, thank you for your interest in our exchanges.
Phil
Hello everyone,
The management of items takes different forms depending on the type of items:
Examples:
- hardware items (screws, brushes, screwdrivers, etc...) will be managed using WAC
- perishable items (ice creams, biscuits, periodicals, etc...) will be managed using FIFO
- items stored on racks (pallets of clothing, shoes, etc...) will be managed using LIFO
- items for which after-sales service must be ensured (computers, pneumatic tools, etc...) will be managed using SERIAL
- items or products for which quality must be tracked by batch or by shipment (medications, raw materials for manufacturing, meat, etc...) will be managed by LOT
What these different acronyms mean:
- WAC - Weighted Average Cost
- FIFO - First In First Out
- LIFO - Last In First Out
- SERIAL - Serial number (unique per item)
- LOT - Lot number (common to all items in the lot or all quantities)
The mechanism behind these choices:
- WAC
-------
This is a method that allows for the valuation of stock according to the movements of stock and deduces an average price per item. For example:
1 - I buy 10 pieces at €5. I have a stock of 10 pieces for a total of €50,
which gives a unit price of 50/10 = €5
2 - I sell 5 pieces from my stock. I have 5 pieces left for a total of €25,
which gives a unit price of 50/10 = €5
3 - I buy 10 pieces at €7, I have a stock of 5 pieces (€25) + 10 x €7 (€70) = 15 pieces for €95,
which gives an average unit price of €95/15 = €6.33
4 - I sell 5 pieces from my stock, I have 5 pieces left for a total of €31.67.
which gives an average unit price of €95/15 = €6.33
We see that:
- the variation in purchase price affects the average cost of the stored items,
- the variation in purchase price affects the total value of the stock (remember to consider stock valuation for the balance sheet),
- the variation in purchase price only affects purchases and never sales,
- there is no particular order of item release since all items have the same average price,
In the commercial management Sage L100, a WAC is calculated per "depot".
- FIFO
------
A typical case of FIFO is the management of hamburgers at McDonald's. In the "kitchen", we produce hamburgers that are placed in chutes. They follow each other in the order of production. At the counter, the hamburgers are therefore sold in the order in which they arrive.
Thus, the first produced (First In) will be the first sold (First Out).
This is the case for perishable items.
- LIFO
------
A typical instance of LIFO is loading a truck for deliveries. We will start loading the truck, from the back, with the last packages that we will need to unload.
Thus, the first loaded (First In) will be the last unloaded (Last Out)
- SERIAL
-------
Items for which specific traceability must be ensured require a unique serial number (e.g., a quality watch). This serial number is assigned to an item that is part of a number of pieces and is attributed at the time of stocking, following purchase or manufacturing.
To de-stock (sale or change of depot), one must choose from the serial numbers that are in stock.
In the commercial management Sage L100, a serial number is unique for the same item reference.
- LOT
-----
A lot number can be assigned to a quantity of items of the same reference (or to a volume or weight). For example: I manufacture perfumes. I use an essential lavender oil that must meet very strict manufacturing specifications. I receive 10 canisters of 20 liters corresponding to 3 different productions. Therefore, I will have 3 different lot numbers. Each canister will bear the number of the lot of its production.
Quality analyses on the 3 lots reveal that in 1 of the 3 lots, there are traces of "dioxin". This lot is unusable. Therefore, the canisters corresponding to this lot will be removed from my stock and returned to the supplier.
This is how manufacturers can also do "product recalls" that we hear about on television (baby food jars, sparkling water bottles, cosmetics, etc...)
In the commercial management Sage L100, a lot number must be entered when stocking (purchase or manufacturing) assigned with a quantity (in number of pieces or in volumes or in liters, carcasses of meat animals, etc...). The stock exit will be from one or more lots until they are exhausted. One can choose to perform a uniqueness control of the lot.
I hope I have been clear and educational.
See you later
Phil
The management of items takes different forms depending on the type of items:
Examples:
- hardware items (screws, brushes, screwdrivers, etc...) will be managed using WAC
- perishable items (ice creams, biscuits, periodicals, etc...) will be managed using FIFO
- items stored on racks (pallets of clothing, shoes, etc...) will be managed using LIFO
- items for which after-sales service must be ensured (computers, pneumatic tools, etc...) will be managed using SERIAL
- items or products for which quality must be tracked by batch or by shipment (medications, raw materials for manufacturing, meat, etc...) will be managed by LOT
What these different acronyms mean:
- WAC - Weighted Average Cost
- FIFO - First In First Out
- LIFO - Last In First Out
- SERIAL - Serial number (unique per item)
- LOT - Lot number (common to all items in the lot or all quantities)
The mechanism behind these choices:
- WAC
-------
This is a method that allows for the valuation of stock according to the movements of stock and deduces an average price per item. For example:
1 - I buy 10 pieces at €5. I have a stock of 10 pieces for a total of €50,
which gives a unit price of 50/10 = €5
2 - I sell 5 pieces from my stock. I have 5 pieces left for a total of €25,
which gives a unit price of 50/10 = €5
3 - I buy 10 pieces at €7, I have a stock of 5 pieces (€25) + 10 x €7 (€70) = 15 pieces for €95,
which gives an average unit price of €95/15 = €6.33
4 - I sell 5 pieces from my stock, I have 5 pieces left for a total of €31.67.
which gives an average unit price of €95/15 = €6.33
We see that:
- the variation in purchase price affects the average cost of the stored items,
- the variation in purchase price affects the total value of the stock (remember to consider stock valuation for the balance sheet),
- the variation in purchase price only affects purchases and never sales,
- there is no particular order of item release since all items have the same average price,
In the commercial management Sage L100, a WAC is calculated per "depot".
- FIFO
------
A typical case of FIFO is the management of hamburgers at McDonald's. In the "kitchen", we produce hamburgers that are placed in chutes. They follow each other in the order of production. At the counter, the hamburgers are therefore sold in the order in which they arrive.
Thus, the first produced (First In) will be the first sold (First Out).
This is the case for perishable items.
- LIFO
------
A typical instance of LIFO is loading a truck for deliveries. We will start loading the truck, from the back, with the last packages that we will need to unload.
Thus, the first loaded (First In) will be the last unloaded (Last Out)
- SERIAL
-------
Items for which specific traceability must be ensured require a unique serial number (e.g., a quality watch). This serial number is assigned to an item that is part of a number of pieces and is attributed at the time of stocking, following purchase or manufacturing.
To de-stock (sale or change of depot), one must choose from the serial numbers that are in stock.
In the commercial management Sage L100, a serial number is unique for the same item reference.
- LOT
-----
A lot number can be assigned to a quantity of items of the same reference (or to a volume or weight). For example: I manufacture perfumes. I use an essential lavender oil that must meet very strict manufacturing specifications. I receive 10 canisters of 20 liters corresponding to 3 different productions. Therefore, I will have 3 different lot numbers. Each canister will bear the number of the lot of its production.
Quality analyses on the 3 lots reveal that in 1 of the 3 lots, there are traces of "dioxin". This lot is unusable. Therefore, the canisters corresponding to this lot will be removed from my stock and returned to the supplier.
This is how manufacturers can also do "product recalls" that we hear about on television (baby food jars, sparkling water bottles, cosmetics, etc...)
In the commercial management Sage L100, a lot number must be entered when stocking (purchase or manufacturing) assigned with a quantity (in number of pieces or in volumes or in liters, carcasses of meat animals, etc...). The stock exit will be from one or more lots until they are exhausted. One can choose to perform a uniqueness control of the lot.
I hope I have been clear and educational.
See you later
Phil
Hello Mr. ppa;
Thank you very much for all your explanations, they are clear and precise.
Please, could you clarify for me: how does SAGE value inventory (calculate the amount of stock) for each method, after a goods exit or delivery what will be the amount of stock?
I believe it differs depending on the inventory tracking method.
Best regards.
Thank you very much for all your explanations, they are clear and precise.
Please, could you clarify for me: how does SAGE value inventory (calculate the amount of stock) for each method, after a goods exit or delivery what will be the amount of stock?
I believe it differs depending on the inventory tracking method.
Best regards.
Hi
I'm working on Sage Gescom V12 and I'm struggling to display VAT on invoices and quotes
Is there an angel to help me?
Guy Mahilet
I'm working on Sage Gescom V12 and I'm struggling to display VAT on invoices and quotes
Is there an angel to help me?
Guy Mahilet
Hello
In which tab can I find the actual stock knowing that I have, for example, a minimum stock of 5 and a maximum stock of 10, and I want an actual stock of 4?
In which tab can I find the actual stock knowing that I have, for example, a minimum stock of 5 and a maximum stock of 10, and I want an actual stock of 4?
Hello, I would like to know how to start good inventory management in Sage Integral...
Manage and change actual stocks, dates, etc... Thank you.
Manage and change actual stocks, dates, etc... Thank you.
Your project is feasible
To see the links between the Sage tables, you need to use the Enterprise Manager diagram.
Wanting to exploit the data is very ambitious and makes your project obsolete because with each update, all or part may need to be redone.
Business objects allow for developing your own interface and accessing the data from the database or calculated values both in read and write modes. With business objects, it is possible to redevelop the entire Sage interface.
Best regards
To see the links between the Sage tables, you need to use the Enterprise Manager diagram.
Wanting to exploit the data is very ambitious and makes your project obsolete because with each update, all or part may need to be redone.
Business objects allow for developing your own interface and accessing the data from the database or calculated values both in read and write modes. With business objects, it is possible to redevelop the entire Sage interface.
Best regards
Thank you very much for your responses.
Well, this is my graduation project and I am pleased with your interest in my topic.
I have another question:
Does Sage handle payment effects that have a due date, and in this case, even if the invoice is settled by this effect, it is still added to the outstanding amount if the due date of the effect has not yet arrived?
The Sage problem "Processing/Managing payments/Entering payments" does not allow you to enter the payment date of the effect.
I hope you have understood my problem regarding the outstanding amount.
Thank you again.
From the sales team's perspective, an invoice is considered settled from the moment the company receives a financial instrument. This is why entering payments in the accounting system triggers a matching process during accounting if the payment is associated with an invoice.
If the financial instrument is a LCR/BOR, the use of this instrument depends on accounting, which will handle it according to cash flow needs (collection or discounting).
In the case of a LCR/BOR, it would be advisable to indicate the payment method, the journal "EEP" (Effects In Portfolio) or "EAR" (Effect To Receive), and the general account 413xxxx. The EEP or EAR journals are "General" or "OD" journals. This would constitute the most academic method since the accounting system.
Very often, payments are received by mail and sent directly to accounting, which processes the financial instruments and transfer notices itself with the most appropriate entry.
Regarding the outstanding balance, the triggering element for removing the balance is the matching (associating invoice and payment stage) done either automatically or manually.
Furthermore, if the LCR/BOR is not settled (drawer’s account not funded, due date extension, etc.), accounting records a adjusting entry, debiting the third party account with the amount incorrectly matched. This results in bringing this entry back into the outstanding balance.
Alright, by consolidating all these emails, we’ll be able to create a chapter on the payment mechanism.
Later,
Phil
thank you for reaching out
I didn't fully understand your message (a lot of accounting terms)
According to you, to calculate what we owe to the client:
customer balance = (portfolio BC, BL, FA) + accounting balance
Let's take an example of an invoice settled with a promissory note whose due date has not yet arrived,
what is the due date of a promissory note again? Is it handled by Sage? From what I know, when entering a payment, we cannot enter its due date??????????
Excuse me for too many questions
Thank you
That's correct!
What the client owes us: Client account = (Sales order + Delivery note + Invoice) + accounting balance
DUE DATE:
1) There is the due date of the invoice: This is the date by which the client MUST have paid their invoice.
2) The due date of a bill of exchange (LCR/BOR) is the date on which the client promises to have the funds transferred by THEIR bank. This is what we call the "settlement" of the bill. Let’s not forget that a bill of exchange is just a promise and not a financial value.
If the "client" is an economically reliable company, OUR bank may agree to advance the money before the due date of the bill. This is known as "discounting" the bill.
THE ACCOUNTING BALANCE:
The invoice leaves the account balance when the invoice is matched by the accounting with a payment.
Knowing that an unexpired bill of exchange and therefore not settled has no financial value, this bill still represents a risk and should not be matched with the invoice (therefore leaving the account balance).
In many companies, for the sake of simplifying processes, it is often considered that a bill can be matched with the invoice. In case of "non-settlement", this matching is then canceled and the invoice returns to the account balance. However, during the year-end financial closing, it is important to make the distinction.
For you, you should consider that the accounting balance is the sum of all unmatched invoices.
Is this better?
Phil
I have two more questions:
1) Where do we enter the due date of a bill in the Sage interface?
2) Does the software block you if you perform the matching of an invoice with a payment (bill) where the compensation date has not yet arrived? Or does it still take them out of the balance anyway?
Thank you very much.