ERP Data Structure (was.- Re: wild card in an index)

[Jose Lerebours]

On 9/17/21 8:21 AM, Walter Vaughan Jr via Filepro-list wrote:
> When we transitioned to the ERP we currently use back in 2008, I thought it was sort of useless with the number of tables that had rows with TrnMonth and TrnYear as populated fields. However over time I have discovered it makes it so much easier to pull data for reporting, and a grateful for that fact almost on a daily basis.

Not for every possible module but, for some, specially General Ledger, I 
keep a ytd-by-month table where I can keep net figures for customers, 
products, control accounts. As in your case, I have found it to be very 
useful and most so when drawing charts on the dashboard; since the data 
is nicely stored the retrieval is instant and impressive (if I may say so).

In my case, the General Ledger is one I like to do that for since I can 
give my customer an instant snapshot of the activity for any account for 
any year for the entire history of their business (or at least for as 
long as they have been using the application).

Hell, I landed a GSA account mostly because the dashboard charts and the 
ability to navigate through monthly/yearly activities in less than two 
seconds.

I am currently pitching a manufacturing company out of LA where they 
need to do identical things and they loved my integration between 
product development, pick & pack, cargo receipts and dispatch (specially 
the ability to send freight info out to over 30 common carriers and get 
quotes inside of 10 seconds).

lol - Wait till I show them the integration with external services such 
as Google WorkSpace, Twilio, MailChimp and a couple others.

-- 
Jose Lerebours
(954) 559-7186
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210917/5e3cfcda/attachment.html>