26

(1 replies, posted in Setup)

Hey, is there any option or way to make 1 master copy of any company with database e.g

I have one company with database name 1_tsstg
Is there any way that every recording in that company tsstg will be recorded in 0_master_tsstg company.

So, if anyone access that master company it will see all data as same as tsstg company.

Any solution for this rather replacing database.sql files im phpmyadmin.

Regards

hey,

thanks for respond to me!

Encounter! Done!

well, i have one more question,

how can we remove the install/active extension files and use as manual installation via upload to modules folder because some of your install/active extension is not updated or maybe not download updated files from repo, so is there any possibility that we can break it or use a manual upload to modules/folder

https://imgur.com/a/c9Ccpu7

hey,

thanks for respond to me,

well, i am tried to encounter an errors which is i found is here

DATABASE ERROR : Could not query chart_master table
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= account_code' at line 1
sql that failed was : SELECT account_code FROM 0_chart_master WHERE = account_code

any solutions?

hey, thanks for reply

well, i have checked it for the purpose of reference i used now 001/2019
for the DB issue,
i have created a new company such as demo and now try to do in it.
but nothing error is found and when we click process without trial its again show to me as i have disclosed image above.

can you please guide me for this or any other ways to do?

hey,

thanks for respond to me;

well, i have un-tick the TRIAL RUN already the same this is occur i have also attached a image for you

https://imgur.com/a/M3hfkrF

Regards

hey,

Thanks for responding to me.
Well we have first worked on our demo server then went live.

Well, I have checked and replaced files download from your repo!

The module is now working but when we make .csv and upload it, it shows to me:

Bad debts using account 8100 (Reference: 101)
2:1065
Added to table 'bank_trans': 11, 2, 101, 10/01/2019, 1000, 0, (line 2 in import file journal_en_GB.csv')
Added to table 'gl_trans' Debit bank account: 11, 10/01/2019, 1065, 0, 0, 1000, Bad debts using account 8100 (Reference: 101) , 0, (line 2 in import file 'journal_en_GB.csv')
Debtors Control using account 1100 ( Person: 2, Reference: 101)
3:1060
Added to table 'bank_trans': 11, 1, 101, 10/01/2019, -1000, 2, 2 (line 3 in import file 'journal_en_GB.csv')
Added to table 'gl_trans' Debit bank account: 11, 10/01/2019, 1060, 0, 0, -1000, Debtors Control using account 1100 ( Person: 2, Reference: 101) , 2, 2 (line 3 in import file 'journal_en_GB.csv')
(Reference: )

This means there is no error but when we  checked the Journal inquiry nothing entry is recorded!

What can I do?

hey,

can anyone help me regarding this module when i install and active this module its destroy the FA

i have attached image for better understanding

https://imgur.com/a/XehZzXB

tested on version 2.4.4 , 2.4.5 and v2.4.6

regards

*or any module is here for transaction import?

33

(4 replies, posted in Reporting)

yes done, thanks

34

(4 replies, posted in Reporting)

dear apmuthu,

i have reviewed the files header , doctext and rep107

in header you have put the various thing like logo, name, adre etc

but i am unable to find the top margin section where we want to print some background color;

second, we have download a font like ' QuickSand ' in .ttf and this font is also converted into TCPDF like ' QuickSand.php '

after putthing the font files in fonts/folder and change the name of font into Quicksand its said,

' the font qicksand.php is not exist. can you tell me how can we encounter this issue first

regards

35

(12 replies, posted in Reporting)

yeah, mine too! another way

36

(11 replies, posted in Banking and General Ledger)

Thanks "joe,
i will take a look for this

37

(4 replies, posted in Reporting)

hey,

i am trying to change the template of invoice it means that i want to create my own invoice template in attractive manner,

i have study your code like rep and study TCPDF examples too,

can you please tell me which files i need to consider for this

what i want ;

1. header - > in which logo and details of invoice after logo
2. body -> data of invoice
3. footer -> only some legal terms and approval

let me know about that

second if you have some example too or some changes code then share with me

Regards

38

(5 replies, posted in Banking and General Ledger)

hey,

In direct invoice we only give the orders i mean sale of items and
sales to be CR
after generating invoice its automatically set the others DR or CR or DR and CR

this thing is not in Invoice and other

is there any way we can give a code that first enter DR and then CR, possible in CODE

ok, not clear to me, well i give a

Save Report Selection Days: 7
Default Report Destination: PDF
Default Report Orientation: Portrait

now i need to generate a report like Trial Balance its in my location at /company e.g

/company/1/pdf_files/lwJWpwhO56tNc1d-27WOggxx.pdf

now after 7 days the Trial Balance Report update automatically?

40

(6 replies, posted in Setup)

yes,

do you have any tutorial or image for my guidance...

Regards

hey,
but it seems that the reports are automatically saved in any folder where we can access it without login or etc,

second, i am not clearly about your lines like from choices....

42

(5 replies, posted in Banking and General Ledger)

ok, i understand but in Direct invoice its come as

cr dr cr

hey,

can you please let me know about that what is the function of Save Report Selection Days: in SETUP -> DISPLAY SETUP -> REPORTS ..

regards

i think the dummy account A_ is not a solution,

it must be shown empty fields for add new supplier / customer,

45

(6 replies, posted in Setup)

i mean that FA is in Android version too?

46

(5 replies, posted in Banking and General Ledger)

Hey,

can you please tell me how can we arrange of entries in GL like

Dr then Cr

in GL your system shown to me;

Cr , Dr , Cr

can we do that first all Dr amount shown and than all Cr amount shown

image attached: https://imgur.com/a/guajKfb

47

(11 replies, posted in Banking and General Ledger)

hey, you mean that need to leave it ? or user code as

display : none;

regards

48

(6 replies, posted in Setup)

hey,

can you please inform me about andriod version like FA has any android app where we can download reports etc?


let me know..

regards

and second this thing is not good because when we click ADD NEW or PRESS F2 the popup is open for add new,

but in this popup this is not showing add new page its showing the default or top name started from 'a ...

how can we do that the popup page only shown as new addition.

Regards

hey,

if we dont want to do that i mean if we want to remove such restriction that is it possible?