1 (edited by anoopmb 07/16/2013 06:04:19 pm)

Topic: fa modified with batch number , MRP and expiry date for items

hi,
am anoop from India owner of a small pharma marketing company.First of all thanks very much to FA for this great product.
i have started using this software from last week after modification of my own. As i am dealing with pharma products it is very indeed to have batch number,expiry date for items and licence numbers for suppliers and customers

my modifications include following:-
- added licence number for our company,supplier,customer
-added CST and interstate c-form purchase @1% tax
-added batch number to items
-added batch wise expiry date,mfg date,packing type,mrp
-new calculation  in tax on mrp
-removed discounts and added free (quantity wise)
-batch wise item status
-month picker for expiry date and mfg date
-modified invoice,sales order purchase reports etc..
and more

if anyone interested please reply i will post the demo and source soon

ANOOP
Experience is the name everyone gives to their mistakes!

Re: fa modified with batch number , MRP and expiry date for items

Hi anoop,

I am Piyush from Gujarat. I am going to start pharma distributorship in next week.
i m interested in your post kindly post demo and source it will be very usefull to me.

Re: fa modified with batch number , MRP and expiry date for items

If these changes are submitted to the project, then it might be included as an addon (aka textcart) or into the core so that with version changes in FA, all would be faithfully carried forward.

Re: fa modified with batch number , MRP and expiry date for items

Hi  Anoop

It is great to see your interest in FA. Is it possible to send me the link to the demo?
Regds

Tariq

Re: fa modified with batch number , MRP and expiry date for items

Hi tor,
currently my hosting is expired and i will upload the demo to any free hosting and i will post here soon.


Also am currently developing sales force automation which includes

-daily call report(dcr) for sales representatives

-doctors master includes their profile visit time,visit days etc

-chemist master

-stockist master

-employee master and payroll system

-internal mailing system

-monthly tour program for sales reps

-expense report for sales reps

-leave structure for employees

-and reports and inquiries for above


if anyone want to help or support kindly let me know


thanks
anoop

ANOOP
Experience is the name everyone gives to their mistakes!

Re: fa modified with batch number , MRP and expiry date for items

i want the source code


romendro2@gmail.com

Re: fa modified with batch number , MRP and expiry date for items

can you at least tell me how to do it? I will be dealing with chemical product, so I will add some chemical data like mass, density, or anything else. I am still new to front accounting so I need a lot of example how to modify it.

Re: fa modified with batch number , MRP and expiry date for items

hi im interested in your modifications , where can i download it?

9 (edited by anoopmb 02/23/2014 12:49:54 pm)

Re: fa modified with batch number , MRP and expiry date for items

Hi,
First Thank You Very Much  FA Team for making this wonderful software

demo posted give feedback please

FrontAccounting with Batch and Expiry Demo

user: demo
pas:user

Added Features:
1. Added Licence info for Company,Suppliers and Customers
2.Added Batch Number, Expiry Date, Manufactured Date and MRP(Maximum Retail Price)
3.Added Packing Types for Items
4.Added Tax on MRP
5.and more just checkit out and reply


Notes I have not modified Manufacturing Module if needed then I will

Also Now Working(almost completed) on Inquiry and Reporting Section with batch details it will publish soon

I have also developed modules sales force automation especially for pharma
modules include

-employee master
-doctors
-chemists
-users
-stockists
-daily call reports
-tour programme
-internal mail system
-sale reports and other reports

One more thing also developing(its in half stage) android application syncing with FA in sales

Source will be published after feedback's and thereafter changes 

because there may be errors or bugs as it is first release...
thank you very much

ANOOP
Experience is the name everyone gives to their mistakes!

Re: fa modified with batch number , MRP and expiry date for items

Sounds interesting, however shouldn't the batch be decided when dispatching instead of when ordering ? I mean at a Customer level ? Otherwise it's more a variation than a batch (even though I would be more interested in variations that batches as such).


/Elax

11 (edited by anoopmb 02/27/2014 04:48:37 am)

Re: fa modified with batch number , MRP and expiry date for items

Actually I didn't get your question.

Basically I modified FA for my use in Pharma products where there is no batch selection at customer level. If the product expired or near expiry it will returned to first point of sale. So if you have any suggestions please tell we can improvise it.

if you asked about entering batch details in purchase order entry form, batch numbers and expiry dates are decided at the time of manufacturing.

ANOOP
Experience is the name everyone gives to their mistakes!

Re: fa modified with batch number , MRP and expiry date for items

What I mean is if you remove all the fields you added (expiry date and others) which are specific to your industry, the batch number can be seen a sub-type of item. What I mean is Item "A" -  Batch "B" is equivalent to a new Item "A-B".
The only difference is (I guess) you don't need to create a new Item each time a new batch comes and of course you can manage all the batches as a single object . I mean you can set/changes the GL Account prices etc, of all the batches of the same item by just modifying it once (on the item) instead of modifying all one by one if they were all distinct item.

This ability to manage "groups" of similar items is definitely lacking in FA, and is usually called (in other system) "variations".
You can have for example the same T-shirt in different colours, let's say red, blue green, in FA
you'll need either to don't track the colour in FA and create 1 T-shirt item, or create 3 differents one

T-Shirt Red
T-Shirt Blue
T-Shirt Green

Etc ...

Your batch modifications could be easily used to manage variations.
I use this concept of variations in my company (mainly colors).

Now, We also have concept of batch which is slightly different. Each delivery of red t-shirt come with a slightly different red.
I need to be able to track what's left for each delivery (or each batch).
I could (we the current FA) create a new item for each  and have T-SHIRT Red 1, T-SHIRT Red 2  etc ...
Now,the main difference between a batch and a variation is Customers Order T-Shirt RED (ie, the order a specific variation).
However, in general they don't care of the bach (They won't order "T-Shirt Red 1" or T-Shirt Red 2"). Moreover,
they can even order before the batch exists (or the purchase order has been decided). In that case there is no way I can select the batch when I enter a customer order.

When I dispatch the good however, I'll need to specify which batch has been used. This is similar to Serial Number tracking (a serial number can be seen as a new batch for every items), the customer doesn't order a specific serial number: he order something, and get one, with a serial number.

I just wanted to clarify those points, because what you've done, I think solves a problems that other people will see as "1 dimensions variations" but not solves problems seens as "batch" or "serial number" tracking.

I'm interested in both ;-)

/Elax

Re: fa modified with batch number , MRP and expiry date for items

ok got it. Its very easy to convert my modifications to your requirement. If you are a developer I can give you the source code or I can help you .

ANOOP
Experience is the name everyone gives to their mistakes!

Re: fa modified with batch number , MRP and expiry date for items

Hi anoopmb,
Please share the code, I'd love to see how you've done your modifications.
ricky.gee12(at)gmail.com

Thanks

Re: fa modified with batch number , MRP and expiry date for items

pls check u r PM... will love if u can share u r code with us

Re: fa modified with batch number , MRP and expiry date for items

Hi i am developer. Modifying FA. I need your FA Modified code.

Thanks and Regards
Selva

Re: fa modified with batch number , MRP and expiry date for items

Hi anoopmb,

I would also like to have the source code.  I have similar needs here for the license and expiry date too.
Kindly PM me.

Thank you.

Re: fa modified with batch number , MRP and expiry date for items

Hello Sir anoopmb,

We are kind to support us to improve our FA I would like to ask if you could share the source code.

my email tahercam@gmail.com. I appreciate the help

Re: fa modified with batch number , MRP and expiry date for items

Hello anoopmb:

could this 'batch' be used to track serial numbers for individual items like electronics/cell phones? These could be many in an inventory.

Is it possible to see hoe the adjustment is made?

thanks!

Re: fa modified with batch number , MRP and expiry date for items

Hi everybody

After sometime am back with the modifications due to so many responses for my code into my email.

Currently am integrating my modifications into latest FA

will post demo  shortly

Also from next work[for custom modifications with a price] onwards I would like to donate a share to my dear FA

ANOOP
Experience is the name everyone gives to their mistakes!

Re: fa modified with batch number , MRP and expiry date for items

Fork on GitHub and post changes

Re: fa modified with batch number , MRP and expiry date for items

Hello Anoopmb,I would also like to have the source code.  I have similar needs here for the license and expiry date too.
Kindly email me the link.corkernel@gmail.com

Thank you.

Re: fa modified with batch number , MRP and expiry date for items

Hi anoopmb

Great development you have made, will you share your code, I'm in need of options like your code deiver:

Licens
Serial no.
Batch
Cure date
etc....
- as our company is supplier to medical industries, that need certificates of garanty with this information.

Thumbs Up !! :-)

Bst. Rgs.,

MicCo

Re: fa modified with batch number , MRP and expiry date for items

Dear Anoop,

I have the needs and I am interested to have your source code.  Many thanks to send the source code to my email at mgatech.mark@gmail.com.

/Mark

Re: fa modified with batch number , MRP and expiry date for items

hi mr anoop your demo site is not working anymore
care to share?
thanks and wbr
Vishal