Hey Guys,
Just a quick question really regarding the database "structure"
I'm linking SAGE to Access in order to develop systems and automate a lot of currently manual procedures - Im using V22 of SAGE.
I'm struggling to get my head around the relationships in the SAGE database - particularly the Audit hierarchy.
So currently i've got:
AUDIT_HEADER.TRAN_NUMBER Joined to AUDIT_SPLIT.HEADER_NUMBER
AUDIT_HEADER.TRAN_NUMBER Joined to AUDIT_JOURNAL.TRAN_NUMBER
AUDIT_SPLIT.TRAN_NUMBER Joined to AUDIT_USAGE.SPLIT_NUMBER
AUDIT_USAGE.SPLIT_NUMBER Joined to AUDIT_JOURNAL.SPLIT_NUMBER
Ideally, I want the payments linked to their invoices and I believe that at some point I need to join on AUDIT_USAGE.SPLIT_CROSSREF at some point, but i'm not sure how?
Any ideas? Or is there a "map" somewhere that details this information?
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
SAGE Database Relationships
-
owen_legend
- User
- Posts: 9
- Joined: 07 Dec 2015, 16:57
- Sage Version: v2016 22 UK/Europe/Africa
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: SAGE Database Relationships
There is no real direct link between invoices and the Audit trail.
INV_REF is the link, but only on Sales Invoices and Credit notes. And only at the header level.
There is no reliable way to link the splits in the audit trail to the items in the invoice.
INV_REF is the link, but only on Sales Invoices and Credit notes. And only at the header level.
There is no reliable way to link the splits in the audit trail to the items in the invoice.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: SAGE Database Relationships
The structure is a Header to one or more Splits which has one or more usages, these also cross link to another split and back to another header.
e.g. Invoice Header> Invoice Items > usages < Payment Split < Payment Header
e.g. Invoice Header> Invoice Items > usages < Payment Split < Payment Header
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 2 guests