Topic: Batch Processing Modifications for FA

Clients coming from legacy accounting systems that have batch processing and posting are wondering if FA could be adapted to process transactions in that manner.

Looking at it I see the following requirements:

1. A "Batch" tab on the main navigation with options below to:
   (a) Create a New Batch
   (b) Select an Existing Batch
   (c) Post a Batch
   (d) Delete a Batch

An auto-generated batch_id could be retrieved from Transaction References.
While a second user supplied description field would make the batch unique.
Date & Time data could be automatic or user entered.

2. These batch_ids would need to be selected when entering Sales or other types of transactions.
    This would require the addition of a drop-down selection for choosing the appropriate batch.

3. In Sales-> Order Entry e.g. there could be a number of batches depending upon purpose.
    Inventory would need to be committed upon Order creation and removed once the batch is posted.
    Similarly released if the batch is deleted.

4. POS would have unique batch_ids based upon register location/id.

5. Batch Listings would need to be run and corrected before any batch could be posted to the G/L.

6. Other considerations such as reporting, etc need to be determined.

I would appreciate comments from the Gurus concerning their thoughts on such an undertaking.

Thanks for your consideration.

bholtz / neholtz

Re: Batch Processing Modifications for FA

This is nice to read. I am actually trying to bring-out with the Batch feature, with that we can allow to use other costing methods as well.  Let's get opinion from other users as well.

Subscription service based on FA
HRM CRM POS batch Themes

Re: Batch Processing Modifications for FA

This sounds great too. Maybe in conjunction with import transaction extension but probably friendlier to execute

innovation-driven technology

Re: Batch Processing Modifications for FA

I am working on a way to send the same invoice to all customers in a group. It's not the same problem, but the requirements are similar, in that each invoice would have a unique tx id and there would be an identifier that would allow them to be selected as a group/batch.

I've been studying the direct invoice process when I have time and trying to decide on the best approach.

Re: Batch Processing Modifications for FA

@oakstreet, maybe have a look at recurrent invoices - select by sales group

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

Re: Batch Processing Modifications for FA

@poncho1234 Thanks, I'll have a look. I thought there was a reason I couldn't use recurring invoices ...

Re: Batch Processing Modifications for FA

Or reuse the existing code???

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

Re: Batch Processing Modifications for FA

@poncho1234 I revisited the recurring invoice feature and I find it does almost what I want, but I cannot figure out how to edit the template invoice. The invoices I'll be generating are varying in # of items and description on the items.

To be very specific, we are invoicing the membership of a fund  that charges all of it's members a small fee every time a member dies, and pays out the sum of those fees to the beneficiary of the deceased. Therefore, once a week, we check to see if there have been any deaths and we list them on an invoice; the fee and the name of the member who died, then invoice all current members according to the # of deaths we've covered.

So, it would be ideal if we could just open a "direct invoice" like interface, enter the appropriate items, select a group of customers, and send out a bulk invoice. I plan to write such a feature, as soon as I figure out the best and most supportable/sustainable way to incorporate it into FA.

If there was an easy way to modify a template and send it to an entire group, that would be great, although it's an additional step, I'd rather use an existing feature so it is easier to install updates to FA as they become available.

9 (edited by poncho1234 07/30/2018 06:24:35 pm)

Re: Batch Processing Modifications for FA

So before you complete this weeks invoice edit the sales group list; edit deceased customers details and remove them from the sales group.
Then create one invoice with the correct items on it, then use this invoice as the template for a recurrent invoice Run the recurrent invoice, after its run once cancel it so it does not run again

If you need to know which customer is in which sales group this post may help

You would then have to do this everyweek, a little bit involved, but a lot easier than writing hundreds of invoices

Also although I've not tested myself but I've seen a topic on here showing how sales prices will affect the sales items prices, when used with recurrent invoices, but cannot find it at this moment - depending on your desired result it maybe worth investigating?


I looked at this myself, but the paradox is automation = non-flexibility, so the more automated the system becomes the less flexible it is, so recurrent invoices = same sale items AND same customers AND same timeframe AND same sales terms AND etc.

For an easier user solution I can only suggest you use the select multiple customers code as in recurrent invoices merged into the existing create sales order code

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

Re: Batch Processing Modifications for FA

@poncho1345 Your suggestion to borrow some code from the recurrent invoices is a great idea. I've started building my own direct invoice code. My next dilemma is how to integrate my "module" so I can keep it working through FA updates. I need to re-read some of the docs as I get closer to making this happen. At the moment, I have to work it into my schedule, and it's hard to juggle all of this stuff in my head while I'm working on other challenging projects.

Thank you, for your suggestions and insights ... very useful stuff.

Re: Batch Processing Modifications for FA

Make a new extension for it.

Re: Batch Processing Modifications for FA

Adding a link in /applications/setup.php to begin working on the Batch Processing project:
The batches directory and the batch_control.php script have been created with minimum interaction at present.

$this->add_lapp_function(0, _("&Batch Control"),
    "batches/batch_control.php?", 'SA_BATCHCONTROL', MENU_SETTINGS);

Displaying below Transaction References OK, but with errors:

Undefined index: SA_BATCHCONTROL in file: /home2/finishl4/public_html/erp/includes/current_user.inc at line 192
/home2/finishl4/public_html/erp/includes/current_user.inc:201:     (current_user Object)->can_access('SA_BATCHCONTROL')
/home2/finishl4/public_html/erp/themes/canvas/renderer.php:224:     (current_user Object)->can_access_page('SA_BATCHCONTROL')
/home2/finishl4/public_html/erp/frontaccounting.php:63:     (renderer Object)->display_applications((front_accounting Object))
/home2/finishl4/public_html/erp/index.php:25:     (front_accounting Object)->display()

A little help as to where to find the SA_ definitions would be appreciated.

Re: Batch Processing Modifications for FA

RE: Batch Processing

apmuthu wrote:

Make a new extension for it.

Would it be better if this subject was moved to Modifications or Development?

Not getting much response under Setup.  Probably should have been submitted under Mods or Dev in the first case.

Just asking if anyone is interested in this or willing to share some insight about getting it done.

Appreciate any suggestions / comments.

Thanks,

bholtz / neholtz

Re: Batch Processing Modifications for FA

I believe you're looking for includes/access_levels.inc

Re: Batch Processing Modifications for FA

Thank you @oakstreet1!

Finding my way around the guts of FA takes a little time.

Onward and upward!