1 Reply by slax

(5 replies, posted in Accounts Receivable)

Hello,

I expect an answer, if there is a possibility offers and instructions for the sponsor program.

Thanks!

Go to forum: Accounts Receivable

2 Reply by slax

(5 replies, posted in Accounts Receivable)

Hi,

I agree with you that the module is very interesting, especially for larger companies and we are interested in sponsoring this model. So if there is a possibility to send us the offer, so we know how much it costs and that it was time for the delivery module?
A formal offer can be sent to my e-mail account, and we would certainly respond to you in a short period of time.

Sincerely,

Slax

Go to forum: Accounts Receivable

3 Topic by slax

(5 replies, posted in Accounts Receivable)

Hello,

I want to ask some questions about create Access Setup for customers, in fact access to the customer or  customer's contact to track their Sales Quotation Inquiry, Sales Order Inquiry, Customer Transaction Inquiry with own username and pasword, is it in plan to create this module?

Thank you in advance for your reply!

Sincerely,
Slax

Go to forum: Accounts Receivable

4 Reply by slax

(6 replies, posted in Items and Inventory)

itronics wrote:

This is set for every branch, not globally. Select the first option of Sales Account select list.
Janusz

Hello,

That's it, I am success to create an invoice with the scheme posting  of account for items.

Thanks and regards,
slax

Go to forum: Items and Inventory

5 Reply by slax

(6 replies, posted in Items and Inventory)

itronics wrote:

The sales account in company setup is used only as defaults for new customer branches.
Sales is posted to gl account set up for customer branch, or if you have selected 'Use items sales accounts' option here - to the gl account set up for selected item. Purchase invoice is always posted to COGS account selected for item.

Therefore if you want to use sales posting to service or goods related accounts you have to set tem properly in items setup for every item, and use the option 'Use items sales accounts' for all customer branches.

Janusz

Yes, I want to use sales posting to service or goods related accounts and I know to set them properly in items setup for every item but I do not know where is option 'Use items sales accounts' for all customer branches?

Thanks,
slax

Go to forum: Items and Inventory

6 Reply by slax

(6 replies, posted in Items and Inventory)

Ok, but what mean set up accounts by category and by product. Because when I enter a new item and set the posting scheme, when receiving the product (Supplier Invoice) application respect scheme accounts set up for new item but when sell item invoice posting by a unique account of income (I have two accounts in the account of income: income from goods and income from services)
How to open item, set the scheme account for posting sales and purchases, and when you sell the item, invoice posting by the scheme set up for this items, and not by default (from company set up)?

thanks for reply,
slax

Go to forum: Items and Inventory

7 Topic by slax

(6 replies, posted in Items and Inventory)

Problem with Item Categories

Table Item Categories ( table _ stock_category) have chart of accounts for each items (table _stock_master), but when we make invoice, sistem do not work with chart of accounts set up for each item or category items. How we can fix it?

thanks for reply,

slax

Go to forum: Items and Inventory

8 Topic by slax

(1 replies, posted in Reporting)

Hello,

Supplier Inquiry, reads data from the table X_supp_trans, where Amount on Supplier Invoice, Bank Deposit is on Debit side and  Supplier Payment, Supplier Credit Note, Bank Payment  is on Credit side, can we replace the values that Supplier Invoice, Bank Deposit is on Credit side and Supplier Payment, Supplier Credit Note, Bank Payment on Debit side? Is it possible to do and how to do the same on the Supplier Balances report?

Best regards,
slax

Go to forum: Reporting

9 Topic by slax

(1 replies, posted in FA Modifications)

Hello,

Jurnal entry write records in the table X_gl_trans with defoult values for the last two fields person_type_id and person_id: 0 or NULL. This process does not establish a connection with customers, suppliers or other transactions.
Is it possible to enter a record to add two more fields (ComboBox), where they could choose person_type_id (0-miscellaneous, 2-customer, 3 - suppliers, ... and I do not know whether there is still something), and depending on the selected specifically person_id.
This Jurnal Entry is very useful to use the application in our region, but it combines three existing processes Jurnal Entry, Bank Payment and Bank Deposite.

Best regards,
Slax

Go to forum: FA Modifications

10 Reply by slax

(2 replies, posted in Items and Inventory)

joe wrote:

We are planning to have an automatic price calculator based on a percent contribution. I cannot promiss when we are implementing this, maybe in 2.2 that are coming later this year.
In your case the factor would be 0% or something like that.

/Joe
BTW you can always 'hardcode' this, I guess it is in the file /sales/includes/ui/sales_orders_ui.inc. The default price is calculated somewhere here.
This is, however, not recommended, because when we ship new sub-releases it will override your changes.

Hi Joe,

I think that the setting of this process, solve my problem described under the theme "Index> Items and Inventory» Purchasing and Sales Pricing" with the possibility of press document that accompanies this process, called the Receive paper.

Best regards!

Go to forum: Items and Inventory

11 Topic by slax

(11 replies, posted in Accounts Payable)

Hello,

In the new version 2.1.4,  there is no calculation of discount on Purchase Order, Receive, Supplier Invoice. Why?
In the beginning I thought that in general a reduction of appropriate supplier, but did not. In our country is often happening that one Supplier Invoice has the items ordered by a price, and after Supplier approved a different discount.

Best regards,
Slax

Go to forum: Accounts Payable

12 Reply by slax

(2 replies, posted in Dimensions)

Thanks Joe,

I am agree with you, it's a better option.

Best regards,
Slax

Go to forum: Dimensions

13 Topic by slax

(2 replies, posted in Dimensions)

Hello,

the difference between Version 2.0.7 and Version 2.1.3 on the Dimensions is the following:
- In the version Version 2.0.7 report by dimensions 1 or 2 is call by # (ordinal number) and the Reference, and gives analytical report with all the documents related to this dimension (Transactions for this Dimension) grouped by accounts (summary)
- In the version Version 2.1.3 report by dimensions 1 or 2 is call by # (ordinal number), and gives for this dimension (Balance for this Dimension) grouped by accounts (summary) without analytics.
Report in Version 2.0.7 is much better and if you can help us how to implement it in Version 2.1.3?

Best regards,
Slax

Go to forum: Dimensions

14 Reply by slax

(9 replies, posted in Banking and General Ledger)

Thanks Joe,

Can you send us a link to download the following files:
/ sales / includes / db / cust_trans_db.inc - revision 1.7
/ reporting/rep101.php - revision 1.7
/ reporting/rep201.php - revision 1.7
  on e-mail ?
We can not find where.

Best regards,
Slax

joe wrote:

Hello slax,
I am afraid that you have run into a bug. When the Bank Payment was used to pay a Customer (normally you use this for supplier payment) the amount was saved with a minus sign in the X_debtor_table (where X is the company number if you use table prefix).
As a side-effect you couldn't allocate this customer payment later, while is did not show up in the allocations.
This routine works OK the other way round (using the Bank Deposits for a Supplier Deposit), so no problem here. But,
The reports Customer Balances and Supplier Balances presented the wrong balance for this odd operations.
All this is now fixed in the CVS Main Repository. You can download the following files:
/sales/includes/db/cust_trans_db.inc - revision 1.7
/reporting/rep101.php - revision 1.7
/reporting/rep201.php - revision 1.7

Unfortunately the records are already saved in the X_debtor_trans table with this minus sign for trans type 1. You can use phpMyAdmin to edit your database, table X_debtor_trans and select View and find the records for trans type 1 and remove the minus sign from the amount.

Then everything will work ok.

/Joe

Go to forum: Banking and General Ledger

15 Reply by slax

(9 replies, posted in Banking and General Ledger)

Hi,

It is OK with Supplier Invoice, Sales Invoice, Supplier Payment, Customer Payment but Bank Payment, Bank Deposite to customer is problem.
I think that is:
Supplier Payment = Bank Payment (on Credit side)
Supplier Invoice = Bank Deposite (on Debit(Charges)side)
and
Customer Payment = Bank Deposite (on Credit side)
Sales Invoice = Bank Payment (on Debit(Charges)side.
Reports on suplier_inquiry.php with
Supplier Payment = Bank Payment (on Credit side)
Supplier Invoice = Bank Deposite (on Debit(Charges)side)
works OK but report on customer_inquiry.php for
Customer Payment = Bank Deposite (on Credit side)
Sales Invoice = Bank Payment (on Debit(Charges)side)
is not ok becouse Bank Payment to Customer is on Credit side (no on Debit(Charges) side in order to be).

Thanks  and Best regards,
salx

Go to forum: Banking and General Ledger

16 Topic by slax

(9 replies, posted in Banking and General Ledger)

Hello,
I am sorry, my English is not so good but I will write to you.
For a long time we are working on FrontAccounting 2.1.3, and we noticed that, as in previous versions, does not work Bank Account Payment Entry to Customer (https://frontaccounting.com/acc3/gl/gl_bank.php?NewPayment=Yes).
Bank Account Payment Entry to Customer (https://frontaccounting.com/acc3/gl/view/gl_trans_view.php?type_id=1&trans_no=12) process is OK, but display the same process of the customer_inquiry.php (https://frontaccounting.com/acc3/sales/ inquiry / customer_inquiry.php?) and (https://frontaccounting.com/acc3/company/1/pdf_files/4a606d3a11e57.pdf) is not ok.
Bank payment (Payment - GL) must be on Charges, not Credit side like (Receipt - GL).
If I did not explained the problem very well, I am here to tell you more details, I am also ready to give a donation, but Montenegro is not between the offered countries.
Best Regards,
slax

Go to forum: Banking and General Ledger

17 Reply by slax

(7 replies, posted in Items and Inventory)

OK, the purchase price of items we have in Purchasing Pricing (or Purchase Order Delivery), spread (the difference in purchase and sales price (in%)) you have to enter at the level of items in the Purchasing invoice to get the price which must go in Sales pricing. The document that we need, can look like Purchasing invoice(Purchase Order Delivery) which added three column: spread, additionally cost and sales price(= purchase price + spread + additionally cost for strange-Ino invoice).
It is link between Purchasing pricing and Sales pricing, which use in a lot of ERP software in our country and print, save like other documents.
Slax

Go to forum: Items and Inventory

18 Topic by slax

(7 replies, posted in Items and Inventory)

Hello,

calculation of the receiving and selling price of items are still missing in the version 2.1, the document price calculation. Do you have plans for the development of this process? If you have any interest, we are ready to help and investment in development.

Best regards!

Go to forum: Items and Inventory