FrontAccounting forum — Purchase Invoice Register

Re: Purchase Invoice Register

2015-08-13T10:05:33Z

By inserting a field in your db table how do you expect it to get populated with any value without providing it in a form to acquire it - the form needs to be displayed anyway along the the label and form field for the newly added field in the FA table.

Please post your exact requirements and offer for customization in the Jobs wanted/offered, non-free offers topic.

Re: Purchase Invoice Register

2015-08-13T08:55:30Z

i didn't need a display i want insertion in to the database only.i create a new filed in my database table and code as like how done for due date but it doesn't work.it takes the value of invoice date only.

Re: Purchase Invoice Register

2015-08-13T05:40:02Z

@sorna: Please post each new issue as a new post in the relevant forum topic. When you get a working solution, please explain it here to help others.

1. Adding extra fields to standard tables will render your installation not upgradeable using normal means.
2. To achieve the same result, make yourself an extension with an additional table with a 1:1 relationship with the parent table (read the wiki and the forum on how to create one) and install it.
3. If the data is trivial, put it into a memo / text field that already exists (remarks, details, description, etc) and use the non field db data method illustrated in adding Bin Locations to Packing Lists.

Re: Purchase Invoice Register

2015-08-13T03:18:28Z

i need additional date field in sales direct invoice page.i tried but it take the invoice date only.what are the steps to add the new column and to obtain the result in the database

Re: Purchase Invoice Register

2015-08-11T13:07:33Z

i got a solution any way thanks for your response

Re: Purchase Invoice Register

2015-08-11T12:28:57Z

Post your custom report requirements in the Jobs wanted/offered, non-free offers board.

Check out all the reports available in FA in the Wiki.

Re: Purchase Invoice Register

2015-08-11T07:34:18Z

shall i able to send the code?? we only create sales invoice register so only.

Purchases => Supplier and Purchasing Reports => Supplier balances => Filter Supplier. is not use for me.i have pdf for sales sales invoice register .how i send pdf

Re: Purchase Invoice Register

2015-08-11T05:10:27Z

Tell us the menu items you clicked in order to get the "sales invoice register" so that we can let you know how to get "purchase invoice register" done in FA.

Does this satisfy your needs?

Purchases => Supplier and Purchasing Reports => Supplier balances => Filter Supplier.

Re: Purchase Invoice Register

2015-08-11T04:21:52Z

i need how PDF is display for sales invoice register like that i need for purchase invoice register how i get that pdf

Re: Purchase Invoice Register

2015-08-10T14:44:43Z

As a trusted ERP that FA is, the sales register is designed to be not easily editable. Just void the invoice and create a new one.

For Purchase Invoices refer this post.

Purchases => Supplier and Purchasing Reports => Supplier balances => Filter Supplier.

Purchase Invoice Register

2015-08-10T14:38:32Z

@sorna's post: How to create purchase invoice register as similar to sales invoice register. Its hard to edit sales invoice register.Please provide me a solution.