1 Reply by alanmi

(5 replies, posted in Manufactoring)

Already checked that and the table are missing, everything else works fine. Restored a backup from where I know the manufacturing still worked as some of the work orders have not been entered and it give me the same error.

So apart from starting from scratch anything else that I can do.

Go to forum: Manufactoring

2 Reply by alanmi

(5 replies, posted in Manufactoring)

FrontAccounting 2.4.4
Current database version     2.4.1

DATABASE ERROR : The work order requirements could not be added
error code : 1146
error message : Table 'frontaccounting.0_wo_requirements' doesn't exist

Go to forum: Manufactoring

3 Topic by alanmi

(5 replies, posted in Manufactoring)

I suddenly cannot do any manufacturing. I cannot produce, nothing happens when I press 'Process and Close'
The same applies for releasing a work order, nothing happens.
Any ideas.

Regards

Go to forum: Manufactoring

4 Reply by alanmi

(8 replies, posted in Reporting)

I did some journal entries, like prompt payment discount, had to use journal to reverse and re-allocate as no tax credit are given for the discount.

Will try in new month and see if I can do better with no journal reversals.

Thanks for the input though.
Regards

Go to forum: Reporting

5 Reply by alanmi

(8 replies, posted in Reporting)

By voided, do you mean under Setup->Void a Transaction? If so, no transactions voided.

Go to forum: Reporting

6 Reply by alanmi

(8 replies, posted in Reporting)

Report 2 Tax are not only rounding, difference are 11 633.37 - 11 135.17 = 498.20.

Also why are there a difference between:
Tax Enquiry = 11633.37 and
General Ledger Reports->Tax Enquiry = 12640.86

3 different results on the same set of books.

Regards

Go to forum: Reporting

7 Reply by alanmi

(8 replies, posted in Reporting)

There are no transactions for 01/02/2018 - 28/02/2018. Started using FA 1/03/2018. To double check I set the tax parameters to tax period 1 and tax last period to 1. Same result if I set my reporting period to 1/3/2018 - 31/3/2018.
Also changed system date to 1/4/2018, no difference except the default dates for the reports are then correct, which would be normal behaviour for FA.

Regards

Go to forum: Reporting

8 Topic by alanmi

(8 replies, posted in Reporting)

I am having trouble with the Tax Inquiry giving me wrong values. I attach the GL Account transactions and the Tax Enquiry screenshot.
According to GL account Transactions the net payable should be 11135.17(this is correct), yet the tax enquiry report either 12640.86 or 11633.37, depending or whether I use Tax Enquiry or General Ledger Reports->Tax Enquiry.
What am I doing wrong.

GL Account Transactions                                   
Print Out Date:    29-03-2018  23:39                           
Fiscal Year:    01-03-2018 - 28-02-2019  (Active)                            localhost   
Period:    01-03-2018 - 31-03-2018                           
Accounts:    2150 - 2150                               
Type    Ref    #    Date    Dimension        Person/Item    Debit    Credit    Balance
2150 Value Added Tax - VAT                Opening Balance                715,855.05   
                                   
Supplier Invoice    002/2018    3    01-03-2018            [00004] Electrocomp    2,394.00        -713,461.05
Supplier Invoice    004/2018    5    02-03-2018            [00001] Mantech    668.49        -712,792.56
Journal Entry    007/2018    7    02-03-2018            Aurinia 165560 Shaft    573.62        -712,218.94
Supplier Invoice    003/2018    4    05-03-2018            [00001] Mantech    58.80        -712,160.14
Journal Entry    002/2018    2    05-03-2018                    46.65    -712,206.79
Supplier Invoice    016/2018    18    14-03-2018            [00009] Cash    117.79        -712,089.00
Journal Entry    006/2018    6    14-03-2018                245.61        -711,843.39
Journal Entry    019/2018    19    15-03-2018            Discount    36.40        -711,806.99
Supplier Invoice    005/2018    6    16-03-2018            [00001] Mantech    51.45        -711,755.54
Supplier Invoice    006/2018    7    16-03-2018            [00001] Mantech    112.70        -711,642.84
Journal Entry    008/2018    8    18-03-2018            Adendorf INPT0357885    290.44        -711,352.40
Supplier Invoice    015/2018    17    20-03-2018            [00009] Cash    289.44        -711,062.96
Sales Invoice    IN002/2018    1    23-03-2018            [00001] Adventure Engineering        5,488.73    -716,551.69
Sales Invoice    IN003/2018    2    23-03-2018            [00001] Adventure Engineering        9,242.32    -725,794.01
Sales Invoice    IN004/2018    3    23-03-2018            [00003] Siemens (Pty) Ltd, Industry Mobility        1,911.44    -727,705.45
Supplier Invoice    001/2018    16    23-03-2018            [00003] Perelec CC    308.96        -727,396.49
Journal Entry    004/2018    4    27-03-2018            Data    122.81        -727,273.68
Journal Entry    005/2018    5    27-03-2018            Mailbox    12.25        -727,261.43
Journal Entry    018/2018    18    27-03-2018            Duplicate        122.81    -727,384.24
Journal Entry    011/2018    11    28-03-2018                13.20        -727,371.04
Journal Entry    011/2018    11    28-03-2018            First car rental 41122084    80.93        -727,290.11
Journal Entry    012/2018    12    28-03-2018            FlySAFAIR 4573055    182.18        -727,107.93
Journal Entry    013/2018    13    28-03-2018            Toll to much        5.10    -727,113.03
Journal Entry    014/2018    14    28-03-2018            Toll to much        5.10    -727,118.13
Journal Entry    015/2018    15    28-03-2018            Duplikaat inskrywig 11    5.10        -727,113.03
Journal Entry    021/2018    21    29-03-2018            VAT not taken on R1000    122.81        -726,990.22
                                   
                Ending Balance                726,990.22

Tax Report                     
Print Out Date:30-03-2018   00:46 +0200 GMT    localhost
Fiscal Year:01-03-2018 - 28-02-2019  (Active)
Period:01-02-2018 - 31-03-2018
Type:Detailed Report

Tax Rate                        Outputs            Output Tax             Inputs          Input Tax       Net Tax
Exempt                       478,003.15          0.00                      0.00             0.00             0.00
VAT 14% 14.00%         118,874.88          16,642.49               -35,779.41    -5,009.12      11,633.37

Total payable or refund                                                                                            11,633.3

Go to forum: Reporting

9 Reply by alanmi

(7 replies, posted in Items and Inventory)

Thank you for the reply.

I am having difficulty understanding the below, do I do this in MySQL or in FA?

Insert the relevant data for printing Packing List

    In the 0_cust_branch.notes field, place your space separated and say a CID# prefixed value (amongst others) of any substitute branch code only if that may need to supercede the branch_code in FrontAccounting to be used for lookup in any external application like:

Frt#2300 CID#35263 Introduced by So and So Owner#Brian

    In the 0_stock_master.long_description field, place your space separated and say a BinLoc# prefixed Bin Location value (amongst others) like:

BinLoc#R12T3B4L6 Clr#Grey

    The above may well indicate that the stock_id is physically located in a warehouse with a loc_code (Location ID) and in Bin Location at Row 12 - Tray 3 - Bay 4 - Left Side, Item 6 with Color Grey'.

Also do I create the directory '/includes' under reporting or should it already be there

Make a copy of the reporting/includes/doctext.inc into company/0/reporting/includes/doctext.inc

Regards

Go to forum: Items and Inventory

10 Reply by alanmi

(7 replies, posted in Items and Inventory)

Does this workaround still apply to FA 2.4.3

For instance the changes in the wiki for:
    Extend line 22 in the function get_customer_trans_details() in the file sales/includes/db/cust_trans_details_db.inc from:

        ".TB_PREF."stock_master.units, ".TB_PREF."stock_master.mb_flag

to

        ".TB_PREF."stock_master.units, ".TB_PREF."stock_master.mb_flag, ".TB_PREF."stock_master.long_description

do not match the cust_trans_details_db.inc in FA 2.4.3 which are
            .TB_PREF."debtor_trans_details line,"
            .TB_PREF."stock_master item
        WHERE (";

So far we like FA, but bin locations are important. Also when receiving the purchased items can a bin be allocated or will it allways be fixed.

Regards
Alan

Go to forum: Items and Inventory